Excel 2007 file takes 8 min to open

[majormayhem]

I have an Excel 2007 file that takes 8 minutes to open. Its a rather large file, 30mb, and it contails several macros. When it finally opens, macros are disabled and I need to manually enable them before I can proceed. So, I have two questions; why does it take so long to open and how can I have those macros enabled?

 

[SuperFerret]

Save it as .XLSM (Macro Enabled Workbook) for the last part (I think)

 

[Michael M]

I guess it will depend on your computers processing ability.
A high spec computer will open it fairly quickly I'd imagine, but a 30Mb file will certainly put a strain on something a bit slower.
Consider looking at reducing formatting of cells, colours of cells, numerous font changes, lots of calculations, etc.
Also do a Ctrl + End on each sheet and see if it is at the end of the data or waaaay down the sheet somewhere.
If so, highlight rows and columns to the end of the sheet and delete them.
Save the workbook and re-open. A file sent to me recently reduced from 9Mb to 1.2Mb because of this problem.
SuperFerret has answered the 2nd question

 

[Ruddles]

I have an Excel 2007 file... When it finally opens, macros are disabled... how can I have those macros enabled?

Add the location of the file to your Trusted Locations: see http://www.mrexcel.com/forum/showpost.php?p=2502840&postcount=9.