Empty Template File is 5mb

[mikeymay]

I have a file that consists of a number of worksheets, all of which are empty other than headers and some pictures that are utilised as macro buttons in each sheet.

Previous WIP versions have been tiny (50k ish) but the latest version has ballooned to 5mb.

I have tried all the usual trick of clearing all rows and columns that are beyond what is used and saved as a .xlsb file but still no joy.

Can anyone help with suggestions to resolve? I am happy to email the file if someone wants to look at it.


Thanks
Michael

 

[RoryA]

Save a copy of the file, then delete each worksheet in turn and save and check the filesize. That should tell you if it's one particular sheet. I'd also look at the pictures - how large were the original files?

 

[mikeymay]

Sorry, no pictures and I meant to say shapes from the Insert ribbon.

 

[mikeymay]

I think I may have found the issue....

I am using the Fuzzy Lookup add-in and whilst testing the build I am running the FL process which creates a hidden sheet called 'FuzzyLookup_AddIn_Undo_Sheet'.

Taking this sheet out has taken the file back down to it's expected size.