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
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
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.
see here too
http://www.ozgrid.com/forum/showthread.php?t=20847
Will
Not all chemicals are bad. Without chemicals such as hydrogen and oxygen for example, there would be no way to make water, a vital ingredient in beer.
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
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.
~Anne Troy
If you set calculations to manual and disable macros can you open the file??
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.
skulakowski: Thanks for that. I ALWAYS forget that!! I must have it beat into my head, I suppose...
And welcome!
~Anne Troy
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.
What size is the file, both unzipped and zipped?
Regards
Ken..................
It's easier to beg forgiveness than ask permission