Problem opening Huge XLs file

[helmekki]

Hi all

About 10,000 row and 30 column Xls file, the Excel can not open it......(full of formulas and macros)

i do not why........

could any one pls give some hints?

yours
hesham :dunno

[Jacob Hilderbrand]

Can you post some more info about your PC specs like memory, processor speed, version of windows, version of Excel.

When you say it won't open what exactly happens, does the computer just freeze?

Just for starters try opening Excel first and let it fully load then from Excel open the file and see if that helps (as opposed to just opening the file from windows).

Also if there are any macros running disable them to see if that helps at all.

[WillR]

see here too

http://www.ozgrid.com/forum/showthread.php?t=20847

[helmekki]

Hi WillR

my huge xl file is full of formulas and macros
the computer info:
memory is 40G

Ram 256

Speed 512 pantuim4

windows xp

Excel 2003

other of xls can normally be openned

Excel software is completely loaded

any more ideas are wellcomed

yours
hesham

[Anne Troy]

What size is the file zipped? Can you get an older copy of the file off of some network server or any sort of backup at all?

Do you know that if you open a new blank Excel workbook, you can often type a link to your bad file? Here's the syntax: =[test.xls]Sheet1!A1

But if you don't know the names of the worksheets, I'm not sure how we'd do that.

[Jacob Hilderbrand]

If you set calculations to manual and disable macros can you open the file??

[skulakowski]

Try openoffice (http://www.openoffice.org). Openoffice has been able to open files that Excel refused to open, saving my sorry tush on more than one occasion.

[Anne Troy]

skulakowski: Thanks for that. I ALWAYS forget that!! I must have it beat into my head, I suppose...

And welcome!

[Kelly]

I just want to say that in the past I have opened humongous files that were apparently not opening but really they WERE opening -- just opening veeeerrrrry sloowwwly.

What I mean is, I once had a similar situation, so I did 'File' menu, Open.. and chose the file, then I left my computer alone for about 20-30 minutes, and finally the thing opened.

Don't know if that would work for you, Helmekki.

[Ken Wright]

What size is the file, both unzipped and zipped?

Regards
Ken..................