help - excel file not opening

[excelnewbie716]

hi,

I applied a couple of formulas to entire columns which drastically increased the file size. now i can't open the file. i tried changing the calcuation to manual but that didn't help. please help!

[daffodil11]

Do you have a restore point from a few hours ago you can retrieve the file from?

How much of the data do you seek to salvage? Can you lose formatting, style, colors, for example? For something like that you can sometimes view an Excel file's assets by opening the file in a PKZip utility. (first make a backup) You'll have to change filetype in the operating program to include all. There you can see various extraneous content that causes bloat.

Perhaps go into VB editor with Alt+F11 with no workbook active. Summon the Immediate Window with Ctrl+G and type (hitting enter after each line):
Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False

And then try to open it up.

Don't forget to reverse the operations:
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True