Forum Discussion
Excel calculation stopped working
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.
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=trueThere 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?