Forum Discussion

ajackett's avatar
ajackett
New Contributor III
2 years ago
Solved

Linking external Excel Spreadsheet to cube view input spreadsheet

Hi all,  I'm building a cube view which includes pre-filled columns including 12 months for CY budget, PY actuals and columns for YTD actuals. Additionally, I have included all future months in the ...
Cube View
Excel Add In
Reports
  • Larry_Manekin's avatar
    Larry_Manekin
    2 years ago

    Hi,

    Have you tried tried Retain formulas? 

     

Larry_Manekin's avatar
Larry_Manekin
New Contributor II
2 years ago

Hi,

Have you tried tried Retain formulas? 

 

ajackett's avatar
ajackett
New Contributor III
2 years ago

Hi Larry, 

Thanks so much, that's exactly what I was looking for! Was looking everywhere in the add-in settings, but didn't look there!

Cheers

Andrew

  • halbrooks100's avatar
    halbrooks100
    New Contributor III
    13 days ago

    did that resolve your issue? I am finding that even with this checked, it is still hard coding numbers.