Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open excel file problem
Hi all,
This one is really puzzling me, I have an excel file that will open up on most computers but then there is this one computer that when trying to load the file it shuts-down. Any help on what could be causing this would be greatly appreciated. Jason |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open excel file problem
Most of the times this is caused by a macro that refers to a specific memory
address that is reserved by the system. The system then treats this request as an attack and shuts down to prevent from damage. Another possibility is a memory error. I would try to disable macro's and try again to open the file. Werner "Jason Zischke" wrote: Hi all, This one is really puzzling me, I have an excel file that will open up on most computers but then there is this one computer that when trying to load the file it shuts-down. Any help on what could be causing this would be greatly appreciated. Jason |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open excel file problem
Hi Werner
Thanks for the responce but if this true how can I get the macros working again ? Jason "Werner Lueders" wrote: Most of the times this is caused by a macro that refers to a specific memory address that is reserved by the system. The system then treats this request as an attack and shuts down to prevent from damage. Another possibility is a memory error. I would try to disable macro's and try again to open the file. Werner "Jason Zischke" wrote: Hi all, This one is really puzzling me, I have an excel file that will open up on most computers but then there is this one computer that when trying to load the file it shuts-down. Any help on what could be causing this would be greatly appreciated. Jason |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open excel file problem
Hi Jason,
after opening the file save it again under a new name. Afer that, enable macro's from the menu and see if it works. If not, I guess you have a memory failure most likely. I suppose you use the same OS on that specific computer as you use with the other ones? Werner "Jason Zischke" wrote: Hi Werner Thanks for the responce but if this true how can I get the macros working again ? Jason "Werner Lueders" wrote: Most of the times this is caused by a macro that refers to a specific memory address that is reserved by the system. The system then treats this request as an attack and shuts down to prevent from damage. Another possibility is a memory error. I would try to disable macro's and try again to open the file. Werner "Jason Zischke" wrote: Hi all, This one is really puzzling me, I have an excel file that will open up on most computers but then there is this one computer that when trying to load the file it shuts-down. Any help on what could be causing this would be greatly appreciated. Jason |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open excel file problem
Hi Werner,
Yes all the computers are Windows XP, But can I change the name back to the orginal name afterwards so that I don't have to change all my macros and is there a way to fix this so that the file always works so that I don't have to get the user's to do this so that there is no way they they can stuff it up? Jason "Werner Lueders" wrote: Hi Jason, after opening the file save it again under a new name. Afer that, enable macro's from the menu and see if it works. If not, I guess you have a memory failure most likely. I suppose you use the same OS on that specific computer as you use with the other ones? Werner "Jason Zischke" wrote: Hi Werner Thanks for the responce but if this true how can I get the macros working again ? Jason "Werner Lueders" wrote: Most of the times this is caused by a macro that refers to a specific memory address that is reserved by the system. The system then treats this request as an attack and shuts down to prevent from damage. Another possibility is a memory error. I would try to disable macro's and try again to open the file. Werner "Jason Zischke" wrote: Hi all, This one is really puzzling me, I have an excel file that will open up on most computers but then there is this one computer that when trying to load the file it shuts-down. Any help on what could be causing this would be greatly appreciated. Jason |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open excel file problem
I guess you can rename the file afterwards, but i've not tried that yet. The
workaround does not work always, but i recovered several files that way. If you don't mind, give it a try and let me know your results. Werner "Jason Zischke" wrote: Hi Werner, Yes all the computers are Windows XP, But can I change the name back to the orginal name afterwards so that I don't have to change all my macros and is there a way to fix this so that the file always works so that I don't have to get the user's to do this so that there is no way they they can stuff it up? Jason "Werner Lueders" wrote: Hi Jason, after opening the file save it again under a new name. Afer that, enable macro's from the menu and see if it works. If not, I guess you have a memory failure most likely. I suppose you use the same OS on that specific computer as you use with the other ones? Werner "Jason Zischke" wrote: Hi Werner Thanks for the responce but if this true how can I get the macros working again ? Jason "Werner Lueders" wrote: Most of the times this is caused by a macro that refers to a specific memory address that is reserved by the system. The system then treats this request as an attack and shuts down to prevent from damage. Another possibility is a memory error. I would try to disable macro's and try again to open the file. Werner "Jason Zischke" wrote: Hi all, This one is really puzzling me, I have an excel file that will open up on most computers but then there is this one computer that when trying to load the file it shuts-down. Any help on what could be causing this would be greatly appreciated. Jason |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open excel file problem
Is that user really opening the same file or a copy of the same file?
If it's a copy of the same file, I'd try deleting that one and getting a fresh file. If it's the same file (like on a network drive), then it's time for some detective work. Can that user open any file on that pc? If they have trouble with all files, then the first thing I would do is clean up my Temp folder: Close excel windows start button|Run %temp% is a quick way to get there. and delete all the files you can. If that doesn't help, then maybe the toolbar file has gotten corrupted and is causing the trouble. Close excel Use windows search and look for *.xlb (location and name will vary with the versions of windows and excel you used). Rename that *.xlb file to *.xlbOLD restart excel and test it out a bit. This does mean that you'll have to recreate any customized changes to your toolbars, though. If it doesn't help, delete any newly created *.xlb files and rename the *.xlbOLD back to *.xlb. ======== If those two easy suggestions don't help... Chip Pearson has some notes on how to diagnose startup errors: http://www.cpearson.com/excel/StartupErrors.htm And Jan Karel Pieterse has more notes: http://www.jkp-ads.com/Articles/StartupProblems.asp ========================= If this is the only file that has trouble, I think I'd try getting a fresh copy or recreating it. Jason Zischke wrote: Hi all, This one is really puzzling me, I have an excel file that will open up on most computers but then there is this one computer that when trying to load the file it shuts-down. Any help on what could be causing this would be greatly appreciated. Jason -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open excel file problem
Hi Dave
Thanks for responce and it is just a copy of the file and I have already tried to reload it and it still didn't work. Jason "Dave Peterson" wrote: Is that user really opening the same file or a copy of the same file? If it's a copy of the same file, I'd try deleting that one and getting a fresh file. If it's the same file (like on a network drive), then it's time for some detective work. Can that user open any file on that pc? If they have trouble with all files, then the first thing I would do is clean up my Temp folder: Close excel windows start button|Run %temp% is a quick way to get there. and delete all the files you can. If that doesn't help, then maybe the toolbar file has gotten corrupted and is causing the trouble. Close excel Use windows search and look for *.xlb (location and name will vary with the versions of windows and excel you used). Rename that *.xlb file to *.xlbOLD restart excel and test it out a bit. This does mean that you'll have to recreate any customized changes to your toolbars, though. If it doesn't help, delete any newly created *.xlb files and rename the *.xlbOLD back to *.xlb. ======== If those two easy suggestions don't help... Chip Pearson has some notes on how to diagnose startup errors: http://www.cpearson.com/excel/StartupErrors.htm And Jan Karel Pieterse has more notes: http://www.jkp-ads.com/Articles/StartupProblems.asp ========================= If this is the only file that has trouble, I think I'd try getting a fresh copy or recreating it. Jason Zischke wrote: Hi all, This one is really puzzling me, I have an excel file that will open up on most computers but then there is this one computer that when trying to load the file it shuts-down. Any help on what could be causing this would be greatly appreciated. Jason -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open excel file problem
Maybe the tips at Chip's and Jan Karel's site will help.
Jason Zischke wrote: Hi Dave Thanks for responce and it is just a copy of the file and I have already tried to reload it and it still didn't work. Jason "Dave Peterson" wrote: Is that user really opening the same file or a copy of the same file? If it's a copy of the same file, I'd try deleting that one and getting a fresh file. If it's the same file (like on a network drive), then it's time for some detective work. Can that user open any file on that pc? If they have trouble with all files, then the first thing I would do is clean up my Temp folder: Close excel windows start button|Run %temp% is a quick way to get there. and delete all the files you can. If that doesn't help, then maybe the toolbar file has gotten corrupted and is causing the trouble. Close excel Use windows search and look for *.xlb (location and name will vary with the versions of windows and excel you used). Rename that *.xlb file to *.xlbOLD restart excel and test it out a bit. This does mean that you'll have to recreate any customized changes to your toolbars, though. If it doesn't help, delete any newly created *.xlb files and rename the *.xlbOLD back to *.xlb. ======== If those two easy suggestions don't help... Chip Pearson has some notes on how to diagnose startup errors: http://www.cpearson.com/excel/StartupErrors.htm And Jan Karel Pieterse has more notes: http://www.jkp-ads.com/Articles/StartupProblems.asp ========================= If this is the only file that has trouble, I think I'd try getting a fresh copy or recreating it. Jason Zischke wrote: Hi all, This one is really puzzling me, I have an excel file that will open up on most computers but then there is this one computer that when trying to load the file it shuts-down. Any help on what could be causing this would be greatly appreciated. Jason -- Dave Peterson -- Dave Peterson |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open excel file problem
Hi Dave,
Thanks for responce, what is Chip's and Jan Karel's web site? Jason "Dave Peterson" wrote: Maybe the tips at Chip's and Jan Karel's site will help. Jason Zischke wrote: Hi Dave Thanks for responce and it is just a copy of the file and I have already tried to reload it and it still didn't work. Jason "Dave Peterson" wrote: Is that user really opening the same file or a copy of the same file? If it's a copy of the same file, I'd try deleting that one and getting a fresh file. If it's the same file (like on a network drive), then it's time for some detective work. Can that user open any file on that pc? If they have trouble with all files, then the first thing I would do is clean up my Temp folder: Close excel windows start button|Run %temp% is a quick way to get there. and delete all the files you can. If that doesn't help, then maybe the toolbar file has gotten corrupted and is causing the trouble. Close excel Use windows search and look for *.xlb (location and name will vary with the versions of windows and excel you used). Rename that *.xlb file to *.xlbOLD restart excel and test it out a bit. This does mean that you'll have to recreate any customized changes to your toolbars, though. If it doesn't help, delete any newly created *.xlb files and rename the *.xlbOLD back to *.xlb. ======== If those two easy suggestions don't help... Chip Pearson has some notes on how to diagnose startup errors: http://www.cpearson.com/excel/StartupErrors.htm And Jan Karel Pieterse has more notes: http://www.jkp-ads.com/Articles/StartupProblems.asp ========================= If this is the only file that has trouble, I think I'd try getting a fresh copy or recreating it. Jason Zischke wrote: Hi all, This one is really puzzling me, I have an excel file that will open up on most computers but then there is this one computer that when trying to load the file it shuts-down. Any help on what could be causing this would be greatly appreciated. Jason -- Dave Peterson -- Dave Peterson |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open excel file problem
From that other message...
If those two easy suggestions don't help... Chip Pearson has some notes on how to diagnose startup errors: http://www.cpearson.com/excel/StartupErrors.htm And Jan Karel Pieterse has more notes: http://www.jkp-ads.com/Articles/StartupProblems.asp Jason Zischke wrote: Hi Dave, Thanks for responce, what is Chip's and Jan Karel's web site? Jason "Dave Peterson" wrote: Maybe the tips at Chip's and Jan Karel's site will help. Jason Zischke wrote: Hi Dave Thanks for responce and it is just a copy of the file and I have already tried to reload it and it still didn't work. Jason "Dave Peterson" wrote: Is that user really opening the same file or a copy of the same file? If it's a copy of the same file, I'd try deleting that one and getting a fresh file. If it's the same file (like on a network drive), then it's time for some detective work. Can that user open any file on that pc? If they have trouble with all files, then the first thing I would do is clean up my Temp folder: Close excel windows start button|Run %temp% is a quick way to get there. and delete all the files you can. If that doesn't help, then maybe the toolbar file has gotten corrupted and is causing the trouble. Close excel Use windows search and look for *.xlb (location and name will vary with the versions of windows and excel you used). Rename that *.xlb file to *.xlbOLD restart excel and test it out a bit. This does mean that you'll have to recreate any customized changes to your toolbars, though. If it doesn't help, delete any newly created *.xlb files and rename the *.xlbOLD back to *.xlb. ======== If those two easy suggestions don't help... Chip Pearson has some notes on how to diagnose startup errors: http://www.cpearson.com/excel/StartupErrors.htm And Jan Karel Pieterse has more notes: http://www.jkp-ads.com/Articles/StartupProblems.asp ========================= If this is the only file that has trouble, I think I'd try getting a fresh copy or recreating it. Jason Zischke wrote: Hi all, This one is really puzzling me, I have an excel file that will open up on most computers but then there is this one computer that when trying to load the file it shuts-down. Any help on what could be causing this would be greatly appreciated. Jason -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open excel file problem
Hi Werner,
I finally was able to have a go at it, I dissabled the macros then tried the save As to rename it and it just shut-down again, any ideas. Jason "Werner Lueders" wrote: I guess you can rename the file afterwards, but i've not tried that yet. The workaround does not work always, but i recovered several files that way. If you don't mind, give it a try and let me know your results. Werner "Jason Zischke" wrote: Hi Werner, Yes all the computers are Windows XP, But can I change the name back to the orginal name afterwards so that I don't have to change all my macros and is there a way to fix this so that the file always works so that I don't have to get the user's to do this so that there is no way they they can stuff it up? Jason "Werner Lueders" wrote: Hi Jason, after opening the file save it again under a new name. Afer that, enable macro's from the menu and see if it works. If not, I guess you have a memory failure most likely. I suppose you use the same OS on that specific computer as you use with the other ones? Werner "Jason Zischke" wrote: Hi Werner Thanks for the responce but if this true how can I get the macros working again ? Jason "Werner Lueders" wrote: Most of the times this is caused by a macro that refers to a specific memory address that is reserved by the system. The system then treats this request as an attack and shuts down to prevent from damage. Another possibility is a memory error. I would try to disable macro's and try again to open the file. Werner "Jason Zischke" wrote: Hi all, This one is really puzzling me, I have an excel file that will open up on most computers but then there is this one computer that when trying to load the file it shuts-down. Any help on what could be causing this would be greatly appreciated. Jason |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel files in separate program windows | Excel Discussion (Misc queries) | |||
file is locked does not appear in Excel if file already open by an | New Users to Excel | |||
Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Refresh Imported Data - Does the Excel file have to be open? | Excel Discussion (Misc queries) |