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

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

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

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

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

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

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

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

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

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

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

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