Formula References vs Lengthy Formula Updates
I maintain a lot of large sheets - at least 9 per FY with around 190 columns and up to 1,500 rows per sheet.
Within these are many transit timeline formulas for off-shore shipments. These are often in flux, and when something changes, I need to go through each sheet and update the numbers in the column formulas. This can take a while and be a pain.
What I am considering is instead having a separate reference sheet for the numbers. The transit formulas would instead lookup to that sheet and when updates need to happen, it would just be a matter of updating in one place.
Would that work? I am concerned that this would either be too many cell references per sheet (I remember this has been an issue in past, not sure if it still is), or that it would slow down the processing time to a crawl. Due to the size of the sheets, loading them and the reports connected to them can already take a while.
Help Article Resources
Check out the Formula Handbook template!