Forum Discussion
HELP PLEASE! Excel sizing issue!
Hi everyone, First time using this forum so I hope I am doing the right thing! I have created a finance spreadsheet that has a few macros, some fairly (ish) lengthy formulas in it (SUMIFS etc) a...
You mention conditional formatting. That might be an issue. Use a copy of you workbook and delete all rules.
Detlef_Lewin thank you. I made a copy the sheet and deleted all conditional formatting, took a while as sheet kept 'not responding'. It reduced the file size from 19,721kb to 19,716kb. Still just as slow and I would need the conditional formatting in it of course!
- Maybe your workbook contains objects. Locate and destroy. 😎
- I have just noticed as well that although I have freeze panes on, my rows go from 7 to 316?
