Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 147
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 147
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 147
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 147
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 147
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 147
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel files in separate program windows Jason Dove Excel Discussion (Misc queries) 27 October 24th 08 07:58 PM
file is locked does not appear in Excel if file already open by an Leslie New Users to Excel 3 April 10th 06 09:40 PM
Weird File Open/Save As Behavior [email protected] Excel Discussion (Misc queries) 0 December 9th 05 02:26 AM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Refresh Imported Data - Does the Excel file have to be open? tinkertoy Excel Discussion (Misc queries) 0 June 23rd 05 07:51 PM


All times are GMT +1. The time now is 12:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"