Forum Discussion

psc's avatar
psc
New Contributor III
3 months ago
Solved

Cube View Connection Issue with Preserve Excel Format

Hello,

On version 8.5 (could be earlier, but didn't have a need to try) I am trying to create an embedded cube view that retains excel formatting. When I check mark the preserve excel format this works, BUT when I save the report, close it, and reopen it the cube view itself stays a light font vs black. Once I uncheck preserve excel format it reverts back to the expected black font cube view.....Is this a known issue or a way around it? 

Cube View
Excel Add In
  • VANHNGUYEN's avatar
    VANHNGUYEN
    9 days ago

    Hi! I had the same issue and had to work with OS support to resolve. Under preferences, make sure your "invalidate old data when workbook is opened" is set to false. Also I'd also go ahead and set "retain all formatting when saving offline" as true. 

2 Replies

Sort By
  • psc's avatar
    psc
    New Contributor III
    8 days ago

    Thank you!! This worked!

  • VANHNGUYEN's avatar
    VANHNGUYEN
    New Contributor
    9 days ago

    Hi! I had the same issue and had to work with OS support to resolve. Under preferences, make sure your "invalidate old data when workbook is opened" is set to false. Also I'd also go ahead and set "retain all formatting when saving offline" as true.