Good morning Everyone,

I created this large spreadsheet for work which is pulling a lot of data from Bloomberg. The spreadsheet has a bunch of formulas and a macro (pretty simple macro. (size of the file is now 162,188KB. Everytime i try to open the spreadsheet , it freezes. Is there any ways to reduce the size of my file ? or a way to enable me to have the spreadsheet to open and pull the datas it should be pulling?

thank you and have a great day,
Lili