Forum Discussion
Solved
Excel calculation stopped working
I have been using a spreadsheet that summarizes data in a dashboard at the top of the sheet. It had been working fine for several years. Today I added one more row to the underlying data (296 rows ...
There were over 900 formulas and most of them used INDIRECT() - which is a volatile function.
There also were 100+ conditional formatting rules.
I deleted the CF-rules.
I put the data in an Excel table.
I changed the formulas to use structured references.
Everything runs smooth.
The file contains two dashboards.
One in your style and one using an Excel table.
Detlef_Lewin, I could but don't see an option to include a file in my reply.
You probably haven't met the criteria for upload permission yet.
Try upload to a cloud service (OneDrive, Google Drive, etc.).
Try upload to a cloud service (OneDrive, Google Drive, etc.).