serious problem opening file

**stevesunfold** · 10-06-2008, 02:48 PM

hi guys
ive been working on a praticular spreadsheet now for almost 2 weeks and ive been saving it regularly but now i cant open it at al it just freezes
its 3mb admittedly but surely thats not too big???

if anyone has any advice i would gratefully appreciate

as you can guess it was almost almost finished just superficial stuff to do

im so depressed

regards

**stevesunfold** · 10-06-2008, 03:43 PM

all i keep getting is not responding

anyone please?

i have spent so much time on this to just give it up

**VBA Noob** · 10-06-2008, 03:53 PM

See if links help

http://www.cpearson.com/excel/StartupErrors.aspx
http://office.microsoft.com/en-us/he...889831033.aspx

VBA Noob

**stevesunfold** · 10-06-2008, 04:43 PM

hi vba noob
thanks for the reply
i have tried every single one of the steps in bith categories and nothing is any different
ive scanned the file but there is no virus either
im at my wits end thinking it may have all been to no avail

**VBA Noob** · 10-06-2008, 04:45 PM

Have you tried

opening the file on another PC
opening with macro's disable (if you have macro's)

PS. Best to always save a backup for this very reason

VBA Noob

**stevesunfold** · 10-06-2008, 04:48 PM

i havent tried on another pc but have tried disabling macros but that does the same

**stevesunfold** · 10-06-2008, 04:50 PM

something must have happened to it though as i can open other spreadsheets that have macros on

**shg** · 10-06-2008, 04:56 PM

You might try opening it in OpenOffice.

**stevesunfold** · 10-06-2008, 04:59 PM

open office still returns not responding

please please dont say ive lost it all

**VBA Noob** · 10-06-2008, 05:01 PM

So it didn't open in safe mode?

VBA Noob

**stevesunfold** · 10-06-2008, 05:08 PM

nope comes up as not responding

**VBA Noob** · 10-06-2008, 05:21 PM

May not help but for for future reference

http://www.decisionmodels.com/optspeedd.htm

You can also search google for file recovery services but suspect they will charge.

What happens if you right click the icon and create a copy

VBA Noob

**stevesunfold** · 10-06-2008, 05:34 PM

did a system restore - not responding
did copy - not responding

im gutted

**shg** · 10-06-2008, 07:29 PM

If it's any consolation, you will recreate it in 1/4 the time, and it will be much better implemented.

**stevesunfold** · 10-07-2008, 07:56 AM

hi guys

would like to say that i attached it to my works email address and went to work to check it

downloaded it from email and its fine

i then resent it back to my home address saved as another name

but again it wont open

any ideas?

i need to be able to do this at home rather than work as its time consuming and obviously not to be done during work time

regards

i tried removing excel then reinstalling but same old thing....

thanks guys

**Cheeky Charlie** · 10-07-2008, 08:47 AM

At least it's not totally lost...

I'm sure most of the people on this forum have had that "hours and hours and hours down the drain" feeling and nobody's going to be flippant about it!

I wonder if there's something quirky in your personal xls which affects this file in particular. Try unhiding your personal xls (window->unhide) then closing it. Then open your spreadsheet. May help(?)

**stevesunfold** · 10-07-2008, 01:25 PM

not sure i know what you mean charlie by personal xls

**ChemistB** · 10-07-2008, 01:33 PM

If you have general macros which are not stored in that workbook, they will be stored in "personal.xls". To see if you have one, after you open Excel, Windows>Unhide and see if it shows up.

**stevesunfold** · 10-07-2008, 02:26 PM

there is nothing there chemist

to add insult to injury i sent my file to be recovered to a company on the internet and i got an email back saying it wasnt corrupt

to make other matters worse i had code for calendar 8
but on my 2007 version at work it doesnt have this control

jeez im so dissapointed

**broro183** · 10-07-2008, 03:07 PM

hi,

This may have come up in the "optimise speed" weblink but...
Does the file have a lot of calculations (eg vlookups or sumproducts) in it?

If so, try opening the file with manual calculation under Tools - Options - Calculation. I'm not sure if this will help because the setting may be stored within the workbook, if it doesn't help you may need to run a command prompt forcing excel to open the file with manual calc (try googling:
"http://www.google.co.nz/search?sourc...+line+switchesulation

& change the settings in VBE to :"break on all errors" ...

Rob

**stevesunfold** · 10-07-2008, 03:30 PM

cheers rob
ive given up
really miffed and seriously fed up but what the hell whats two weeks work
thanks to all those that tried to help its appreciated