View Single Post
 
Old 09-05-2014, 01:49 PM
excelledsoftware excelledsoftware is offline Windows 7 64bit Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

Sounds like you have a large amount of formulas in your worksheet. This can be fixed by turning the calculation to manual and then calculating the sheet before saving it. The other option is to have your formulas rewritten with a VBA script which is what I do now. I do this on spreadsheets where I have around 50,000 vlookups or countifs to complete.
Reply With Quote