Skip to main content
February 20, 2025
Solved

Cube View Connection Issue with Preserve Excel Format

  • February 20, 2025
  • 2 replies
  • 0 views

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? 

Best answer by VANHNGUYEN

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

May 1, 2025

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. 

pscAuthor
May 2, 2025

Thank you!! This worked!