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.
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.).
OK, here is the Google Drive URL:
https://docs.google.com/spreadsheets/d/13JmhklJdYPWr44al3VgAt4P6ibjbCTQw/edit?usp=sharing&ouid=111524828079692110479&rtpof=true&sd=true
https://docs.google.com/spreadsheets/d/13JmhklJdYPWr44al3VgAt4P6ibjbCTQw/edit?usp=sharing&ouid=111524828079692110479&rtpof=true&sd=true
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.
- Thank you - this is great. How can I dynamically extend the table to include new rows?
- Just add new data under last row. The table grows. And no need to update formulas in the dashboard because of the structured references.