Forum Discussion

lisgis67's avatar
lisgis67
New Contributor
2 days ago

Page Breaks in Excel add-in

We are having an issue with users and page breaks in the excel add-in.   

Example 1:  A user creates a cube view connection and pulls said cube view into an excel worksheet.   The result, however, does not render all the rows.  There is a page break and they are forced to page through to see the rest of the rows.   If I replicate these actions, I do not get the same page break, my results render all the rows on a single page.  No page breaks. 

We went through preferences and other excel settings together to make sure our settings matched.  What is causing this to happen?  What other things can we try to resolve?   The user must have all the rows displayed at once (no page breaks). 

Example 2:  A user creates a quickview only to have the results get cut off with a page break.  If I replicate the quickview, the return does not cut off the rows.  I get everything on the sheet. 

Any hints, tips, etc would be most appreciated. We are trying to determine if this is a OneStream issue?  Microsoft Issue? Excel Settings? 

For reference, we are on OS 9.0.1.   thank you in advance

1 Reply

  • T_Kress's avatar
    T_Kress
    Icon for OneStream Employee rankOneStream Employee

    Here are a couple things you can check.  Not sure if these are the root cause, but I would start here:

    1) Grid Rows per Page on the user ID in security in OS:

    2) These settings in Preferences, not only in OneStream Preferences but also in preferences for that particular Quick View or Cube View: