Dec 22 2021 11:15 AM
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) and conditional formatting in it. It really is not massive or complex! I have made spreadsheets with more in them than this and never had this problem, but...
Last night I added a few columns and formulas etc for something new and then when I saved the file, it took forever! The file size seems to have gone from something like 350kb to nearly 20,000kb! It is incredible slow to open, respond to any activity in it, and save it.
I have tried everything I could find online, from doing ctrl+end and trying to delete rows and columns, to saving as a different file format etc.
I spoke on Microsoft live chat and the guy tried to repair and corruptions etc but there were not any. He couldn't explain to me what had gone wrong within the sheet that made it so big. I have added or done something which has caused it to go massive! The spreadsheet genuinely is not that complex and should not be that big at all!
He tried something to do with add-ons as well but that did not work.
Can anyone help with any ideas?
I would really appreciate anyone that can help at all!
Thank you :).
Dec 22 2021 11:22 AM
Dec 22 2021 11:52 AM
@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!
Dec 22 2021 12:00 PM
Dec 22 2021 12:01 PM
Dec 22 2021 12:03 PM
Dec 22 2021 12:14 PM
Dec 22 2021 12:35 PM
Dec 22 2021 12:38 PM
Dec 23 2021 10:01 AM