I have a large spreadsheet which is 5500 lines, 20 columns and 2.3Mb
It takes quite a while to save and close. Any suggestions on how I can speed it up if at all possible?
Thanks
It takes quite a while to save and close.
- That’s subjective. provide numbers (seconds)
- 2.3 Mb isn’t large
- Which operating system?
- Storing to which storage device?
- Storing to which format?
- Any references to external data?
- Any specialties regarding formula, calculation and iterations?
(I wonder how you expect anybody to answer such question having almost no technical details)
9 seconds to save and close
windows 10
storing to a SSD
storing to .xls format
very few formulas/macros
hopw that helps…