|
Can't Open Saved File
Was merrily working on a file, saving it, etc.. Now when
I try to open it, it gets about half way (as indicated from the blue bar) and just sits there. When I go to the Windows Task Manager the status is "Not Repsonding". The file is indeed large (50mb), and has quite a few calculations involved, but I have larger that I am able to open... If I could just get it open once, I can shear some of the data, to avoid this going forward, but I can't even open it... HELP?! |
What version Excel?
-- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "JEFF" wrote in message ... Was merrily working on a file, saving it, etc.. Now when I try to open it, it gets about half way (as indicated from the blue bar) and just sits there. When I go to the Windows Task Manager the status is "Not Repsonding". The file is indeed large (50mb), and has quite a few calculations involved, but I have larger that I am able to open... If I could just get it open once, I can shear some of the data, to avoid this going forward, but I can't even open it... HELP?! |
2000 SR-1 Professional .... Thanks
-----Original Message----- What version Excel? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------- ------------------ It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------- ------------------ "JEFF" wrote in message ... Was merrily working on a file, saving it, etc.. Now when I try to open it, it gets about half way (as indicated from the blue bar) and just sits there. When I go to the Windows Task Manager the status is "Not Repsonding". The file is indeed large (50mb), and has quite a few calculations involved, but I have larger that I am able to open... If I could just get it open once, I can shear some of the data, to avoid this going forward, but I can't even open it... HELP?! . |
Firstly, can anyone else open the file or is it just you that has the
problem? If just you then it's possible it's your *.xlb file (Toolbar customisation file) is beginning to corrupt, although a 50MB workbook in 2000 probably isn't good anyway (See Charles Williams' site as to Excel'a internal memory limits) http://www.decisionmodels.com/memlimitsc.htm You can try deleting your *.xlb and then opening the file. (You will lose any toolbar customisations) You can try asking someone with Excel 2002 or 2003 to open the file (Agains see Charles' site as to why they will have more luck than you). Besides the memory improvements they also have 'open and repair' options You can try opening it in OpenOffice which is a free officesuite available from www.openoffice.org though it's a 70MB download. It can often open excel files that even Excel can't. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "JEFF" wrote in message ... 2000 SR-1 Professional .... Thanks -----Original Message----- What version Excel? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------- ------------------ It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------- ------------------ "JEFF" wrote in message ... Was merrily working on a file, saving it, etc.. Now when I try to open it, it gets about half way (as indicated from the blue bar) and just sits there. When I go to the Windows Task Manager the status is "Not Repsonding". The file is indeed large (50mb), and has quite a few calculations involved, but I have larger that I am able to open... If I could just get it open once, I can shear some of the data, to avoid this going forward, but I can't even open it... HELP?! . |
Have you tried shutting off the Automatic calculation (Tools-Options-Calculation and
check "Manual") before opening the workbook? -- Regards; Rob ------------------------------------------------------------------------ "JEFF" wrote in message ... Was merrily working on a file, saving it, etc.. Now when I try to open it, it gets about half way (as indicated from the blue bar) and just sits there. When I go to the Windows Task Manager the status is "Not Repsonding". The file is indeed large (50mb), and has quite a few calculations involved, but I have larger that I am able to open... If I could just get it open once, I can shear some of the data, to avoid this going forward, but I can't even open it... HELP?! |
Thanks for the repy: Yes, unsuccessfully
"RWN" wrote: Have you tried shutting off the Automatic calculation (Tools-Options-Calculation and check "Manual") before opening the workbook? -- Regards; Rob ------------------------------------------------------------------------ "JEFF" wrote in message ... Was merrily working on a file, saving it, etc.. Now when I try to open it, it gets about half way (as indicated from the blue bar) and just sits there. When I go to the Windows Task Manager the status is "Not Repsonding". The file is indeed large (50mb), and has quite a few calculations involved, but I have larger that I am able to open... If I could just get it open once, I can shear some of the data, to avoid this going forward, but I can't even open it... HELP?! |
Thanks for the reply:
1. I'm here alone, but have a PC and laptop both trying to open it (resides on network) 2. Tried the *.xlb file fix, no luck 3. I think I will try your websites.... Thanks. "Ken Wright" wrote: Firstly, can anyone else open the file or is it just you that has the problem? If just you then it's possible it's your *.xlb file (Toolbar customisation file) is beginning to corrupt, although a 50MB workbook in 2000 probably isn't good anyway (See Charles Williams' site as to Excel'a internal memory limits) http://www.decisionmodels.com/memlimitsc.htm You can try deleting your *.xlb and then opening the file. (You will lose any toolbar customisations) You can try asking someone with Excel 2002 or 2003 to open the file (Agains see Charles' site as to why they will have more luck than you). Besides the memory improvements they also have 'open and repair' options You can try opening it in OpenOffice which is a free officesuite available from www.openoffice.org though it's a 70MB download. It can often open excel files that even Excel can't. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "JEFF" wrote in message ... 2000 SR-1 Professional .... Thanks -----Original Message----- What version Excel? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------- ------------------ It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------- ------------------ "JEFF" wrote in message ... Was merrily working on a file, saving it, etc.. Now when I try to open it, it gets about half way (as indicated from the blue bar) and just sits there. When I go to the Windows Task Manager the status is "Not Repsonding". The file is indeed large (50mb), and has quite a few calculations involved, but I have larger that I am able to open... If I could just get it open once, I can shear some of the data, to avoid this going forward, but I can't even open it... HELP?! . |
"..(resides on network).."
Have you tried copying it to you HD and opening it? -- Regards; Rob ------------------------------------------------------------------------ <snip |
Thanks, but again no luck.....
"RWN" wrote: "..(resides on network).." Have you tried copying it to you HD and opening it? -- Regards; Rob ------------------------------------------------------------------------ <snip |
Geez, I'm batting 1000 here!.
It's beyond me as both the suggestions I gave have worked for me in the past, albeit my files weren't that big (mind you, I don't profess to being an expert). Have you let it "sit" for an extended period of time? I had a similar occurrence this last week (file opening to a point then task mgr = "Not Responding). I kept ending the task after about a minute or so. Then, by fluke, when I tried opening it again I got called away for about 30 minutes and when I returned it had finished up. Turned out that I had a very "piggish" command ("=SUM(1/COUNTIF(A2:A23896,A2:A23896))") that I'd forgotten about on one of the sheets. I closed the book and set the calc mode to Manual and it opened no problem. When you find it I'd be interested to know what it was ("forewarned is forearmed"). -- Regards; Rob ------------------------------------------------------------------------ "JEFF" wrote in message ... Thanks, but again no luck..... "RWN" wrote: "..(resides on network).." Have you tried copying it to you HD and opening it? -- Regards; Rob ------------------------------------------------------------------------ <snip |
I appreciate the effort! I'm going to let the pig sit and try to open
over-night ... Thanks again. "RWN" wrote: Geez, I'm batting 1000 here!. It's beyond me as both the suggestions I gave have worked for me in the past, albeit my files weren't that big (mind you, I don't profess to being an expert). Have you let it "sit" for an extended period of time? I had a similar occurrence this last week (file opening to a point then task mgr = "Not Responding). I kept ending the task after about a minute or so. Then, by fluke, when I tried opening it again I got called away for about 30 minutes and when I returned it had finished up. Turned out that I had a very "piggish" command ("=SUM(1/COUNTIF(A2:A23896,A2:A23896))") that I'd forgotten about on one of the sheets. I closed the book and set the calc mode to Manual and it opened no problem. When you find it I'd be interested to know what it was ("forewarned is forearmed"). -- Regards; Rob ------------------------------------------------------------------------ "JEFF" wrote in message ... Thanks, but again no luck..... "RWN" wrote: "..(resides on network).." Have you tried copying it to you HD and opening it? -- Regards; Rob ------------------------------------------------------------------------ <snip |
Don't know how sensitive your data is, but if you zip a copy of the file,
how big is the zip file? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "JEFF" wrote in message ... Thanks for the repy: Yes, unsuccessfully "RWN" wrote: Have you tried shutting off the Automatic calculation (Tools-Options-Calculation and check "Manual") before opening the workbook? -- Regards; Rob ------------------------------------------------------------------------ "JEFF" wrote in message ... Was merrily working on a file, saving it, etc.. Now when I try to open it, it gets about half way (as indicated from the blue bar) and just sits there. When I go to the Windows Task Manager the status is "Not Repsonding". The file is indeed large (50mb), and has quite a few calculations involved, but I have larger that I am able to open... If I could just get it open once, I can shear some of the data, to avoid this going forward, but I can't even open it... HELP?! |
It goes from 53,920 KB to 52,142 (so much for packing)
"Ken Wright" wrote: Don't know how sensitive your data is, but if you zip a copy of the file, how big is the zip file? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "JEFF" wrote in message ... Thanks for the repy: Yes, unsuccessfully "RWN" wrote: Have you tried shutting off the Automatic calculation (Tools-Options-Calculation and check "Manual") before opening the workbook? -- Regards; Rob ------------------------------------------------------------------------ "JEFF" wrote in message ... Was merrily working on a file, saving it, etc.. Now when I try to open it, it gets about half way (as indicated from the blue bar) and just sits there. When I go to the Windows Task Manager the status is "Not Repsonding". The file is indeed large (50mb), and has quite a few calculations involved, but I have larger that I am able to open... If I could just get it open once, I can shear some of the data, to avoid this going forward, but I can't even open it... HELP?! |
Something's wrong. I'd expect it be circa 10% of that, unless you have it
full of bitmaps or something like that. You didn't have Winzip set to no compression or something did you? Where I was heading was that if you could get down to say a 10MB file or less and were OK to email it to me, then I'd have a go at recovering it and send it back for you. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "JEFF" wrote in message ... It goes from 53,920 KB to 52,142 (so much for packing) "Ken Wright" wrote: Don't know how sensitive your data is, but if you zip a copy of the file, how big is the zip file? <snip |
Me too -- everything else I Zip gets compacted. For example, I have a very
similar workbook that I was able to reduce fom 54MB to 9MB.... I'm out of ideas, you? Thanks "Ken Wright" wrote: Something's wrong. I'd expect it be circa 10% of that, unless you have it full of bitmaps or something like that. You didn't have Winzip set to no compression or something did you? Where I was heading was that if you could get down to say a 10MB file or less and were OK to email it to me, then I'd have a go at recovering it and send it back for you. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "JEFF" wrote in message ... It goes from 53,920 KB to 52,142 (so much for packing) "Ken Wright" wrote: Don't know how sensitive your data is, but if you zip a copy of the file, how big is the zip file? <snip |
One more note: the workbook is password protected -- not sure if this
matters as it hasn't in the past..... "JEFF" wrote: Me too -- everything else I Zip gets compacted. For example, I have a very similar workbook that I was able to reduce fom 54MB to 9MB.... I'm out of ideas, you? Thanks "Ken Wright" wrote: Something's wrong. I'd expect it be circa 10% of that, unless you have it full of bitmaps or something like that. You didn't have Winzip set to no compression or something did you? Where I was heading was that if you could get down to say a 10MB file or less and were OK to email it to me, then I'd have a go at recovering it and send it back for you. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "JEFF" wrote in message ... It goes from 53,920 KB to 52,142 (so much for packing) "Ken Wright" wrote: Don't know how sensitive your data is, but if you zip a copy of the file, how big is the zip file? <snip |
Did you try the OpenOffice option?
-- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- <snip |
Success at last! After going to the website you recommened (below), the
light bulb went on and I found someone with Excel 2003 and voila! Thanks for all the help http://www.decisionmodels.com/memlimitsc.htm the Found someone with Excel 2003 and they were able to open it. "Ken Wright" wrote: Did you try the OpenOffice option? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- <snip |
Good stuff - Now would be a good time to make a backup copy though :-)
-- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "JEFF" wrote in message ... Success at last! After going to the website you recommened (below), the light bulb went on and I found someone with Excel 2003 and voila! Thanks for all the help http://www.decisionmodels.com/memlimitsc.htm the Found someone with Excel 2003 and they were able to open it. "Ken Wright" wrote: Did you try the OpenOffice option? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 -------------------------------------------------------------------------- -- It's easier to beg forgiveness than ask permission :-) -------------------------------------------------------------------------- -- <snip |
| All times are GMT +1. The time now is 03:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com