Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 12th 05, 08:11 PM posted to microsoft.public.excel.misc
Delbert
 
Posts: n/a
Default Excel Crash - Help!

Multiple users here have this same problem that whenever they open a
particular Excel file, it gives them a "Send Report Error." Weird thing about
it is it doesnt
happen in all their Excel files, only happens to some of them. Also tried
opening
the very same file/s they are having problems with on my machine and it worked
fine.
I have patched Office (SP2), updated Acrobat Reader, updated signatures,
uninstalled/reinstalled Office, and done all the possible troubleshooting on
these machines but still error occurs.

Any help appreciated, thanks!


  #2   Report Post  
Old December 12th 05, 08:21 PM posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default Excel Crash - Help!

Isolate the problem as best you can...........separate the Network from the
Files from the Computers..........move the files about on Jump Drives to help
with this........list specific arrangements where the problem exists and
where it don't......may be a bad leg on the Net, or directory..........

hth
Vaya con Dios,
Chuck, CABGx3



"Delbert" wrote:

Multiple users here have this same problem that whenever they open a
particular Excel file, it gives them a "Send Report Error." Weird thing about
it is it doesnt
happen in all their Excel files, only happens to some of them. Also tried
opening
the very same file/s they are having problems with on my machine and it worked
fine.
I have patched Office (SP2), updated Acrobat Reader, updated signatures,
uninstalled/reinstalled Office, and done all the possible troubleshooting on
these machines but still error occurs.

Any help appreciated, thanks!

  #3   Report Post  
Old December 12th 05, 09:31 PM posted to microsoft.public.excel.misc
Delbert
 
Posts: n/a
Default Excel Crash - Help!

Thanks for your input but all these are not rectifiable since I have opened
the very same files that they are having problems with into another system
and it work fine. They can somehow open other excel spreasheets fine on the
very same network folder where the problematic files are located so it's
telling us that it has nothing to do with the network/directory. I appreciate
the response though....


"CLR" wrote:

Isolate the problem as best you can...........separate the Network from the
Files from the Computers..........move the files about on Jump Drives to help
with this........list specific arrangements where the problem exists and
where it don't......may be a bad leg on the Net, or directory..........

hth
Vaya con Dios,
Chuck, CABGx3



"Delbert" wrote:

Multiple users here have this same problem that whenever they open a
particular Excel file, it gives them a "Send Report Error." Weird thing about
it is it doesnt
happen in all their Excel files, only happens to some of them. Also tried
opening
the very same file/s they are having problems with on my machine and it worked
fine.
I have patched Office (SP2), updated Acrobat Reader, updated signatures,
uninstalled/reinstalled Office, and done all the possible troubleshooting on
these machines but still error occurs.

Any help appreciated, thanks!

  #4   Report Post  
Old December 12th 05, 10:07 PM posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default Excel Crash - Help!

Is there anything in common with the files that cause the problems?.....such
as a similar format, same macros, etc etc?

Vaya con Dios,
Chuck, CABGx3


"Delbert" wrote in message
...
Thanks for your input but all these are not rectifiable since I have

opened
the very same files that they are having problems with into another system
and it work fine. They can somehow open other excel spreasheets fine on

the
very same network folder where the problematic files are located so it's
telling us that it has nothing to do with the network/directory. I

appreciate
the response though....


"CLR" wrote:

Isolate the problem as best you can...........separate the Network from

the
Files from the Computers..........move the files about on Jump Drives to

help
with this........list specific arrangements where the problem exists and
where it don't......may be a bad leg on the Net, or directory..........

hth
Vaya con Dios,
Chuck, CABGx3



"Delbert" wrote:

Multiple users here have this same problem that whenever they open a
particular Excel file, it gives them a "Send Report Error." Weird

thing about
it is it doesnt
happen in all their Excel files, only happens to some of them. Also

tried
opening
the very same file/s they are having problems with on my machine and

it worked
fine.
I have patched Office (SP2), updated Acrobat Reader, updated

signatures,
uninstalled/reinstalled Office, and done all the possible

troubleshooting on
these machines but still error occurs.

Any help appreciated, thanks!



  #5   Report Post  
Old December 12th 05, 10:31 PM posted to microsoft.public.excel.misc
Delbert
 
Posts: n/a
Default Excel Crash - Help!

The only common set on these files are their macros imbedded. Other than that
all of their settings and format are different. We've also tried changing
their macro settings from it's original excel files and had the author of
these files do this for us - still error exist.

Thanks.

"CLR" wrote:

Is there anything in common with the files that cause the problems?.....such
as a similar format, same macros, etc etc?

Vaya con Dios,
Chuck, CABGx3


"Delbert" wrote in message
...
Thanks for your input but all these are not rectifiable since I have

opened
the very same files that they are having problems with into another system
and it work fine. They can somehow open other excel spreasheets fine on

the
very same network folder where the problematic files are located so it's
telling us that it has nothing to do with the network/directory. I

appreciate
the response though....


"CLR" wrote:

Isolate the problem as best you can...........separate the Network from

the
Files from the Computers..........move the files about on Jump Drives to

help
with this........list specific arrangements where the problem exists and
where it don't......may be a bad leg on the Net, or directory..........

hth
Vaya con Dios,
Chuck, CABGx3



"Delbert" wrote:

Multiple users here have this same problem that whenever they open a
particular Excel file, it gives them a "Send Report Error." Weird

thing about
it is it doesnt
happen in all their Excel files, only happens to some of them. Also

tried
opening
the very same file/s they are having problems with on my machine and

it worked
fine.
I have patched Office (SP2), updated Acrobat Reader, updated

signatures,
uninstalled/reinstalled Office, and done all the possible

troubleshooting on
these machines but still error occurs.

Any help appreciated, thanks!






  #6   Report Post  
Old December 12th 05, 10:40 PM posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Excel Crash - Help!

Can you try this on the problem pc's?

Close excel
windows start button|Run
excel /safe
(hit enter)

Starting excel in safe mode disables lots of stuff (macros/addins/toolbars).

Then File|open the workbook

If excel crashes, maybe it's one of those addins/toolbars.

You can disable the addins that are in your XLStart folder and Tools|Addins to
start.

Chip Pearson has some notes on how to diagnose startup errors at:
http://www.cpearson.com/excel/StartupErrors.htm

And Jan Karel Pieterse has more notes at:
http://www.jkp-ads.com/Articles/StartupProblems.htm

====
You could see if its the toolbar file, by:
close excel
windows search
search for *.xlb
(in hidden folders for hidden files, too)

Rename all the *.xlb files you find to *.xlbOLD

Then restart excel and see if that helps.

If it does, then rebuild any customized changes to the toolbar at your
convenience.

If it doesn't, then close excel and rename all those *.xlbOLD back to *.xlb.

====

And since it's only happening on a few (assuming the same version of excel),
maybe you can use:
help|detect and repair (if that's available in your version)

or even reinstalling excel on those pc's would help.


Delbert wrote:

The only common set on these files are their macros imbedded. Other than that
all of their settings and format are different. We've also tried changing
their macro settings from it's original excel files and had the author of
these files do this for us - still error exist.

Thanks.

"CLR" wrote:

Is there anything in common with the files that cause the problems?.....such
as a similar format, same macros, etc etc?

Vaya con Dios,
Chuck, CABGx3


"Delbert" wrote in message
...
Thanks for your input but all these are not rectifiable since I have

opened
the very same files that they are having problems with into another system
and it work fine. They can somehow open other excel spreasheets fine on

the
very same network folder where the problematic files are located so it's
telling us that it has nothing to do with the network/directory. I

appreciate
the response though....


"CLR" wrote:

Isolate the problem as best you can...........separate the Network from

the
Files from the Computers..........move the files about on Jump Drives to

help
with this........list specific arrangements where the problem exists and
where it don't......may be a bad leg on the Net, or directory..........

hth
Vaya con Dios,
Chuck, CABGx3



"Delbert" wrote:

Multiple users here have this same problem that whenever they open a
particular Excel file, it gives them a "Send Report Error." Weird

thing about
it is it doesnt
happen in all their Excel files, only happens to some of them. Also

tried
opening
the very same file/s they are having problems with on my machine and

it worked
fine.
I have patched Office (SP2), updated Acrobat Reader, updated

signatures,
uninstalled/reinstalled Office, and done all the possible

troubleshooting on
these machines but still error occurs.

Any help appreciated, thanks!





--

Dave Peterson
  #7   Report Post  
Old December 12th 05, 10:44 PM posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default Excel Crash - Help!

Maybe with security setting high, try to open one of the errant files
without enabling the macros....just to see if that can be identified as
where the problem is.....if so, then the macros can be enabled/disabled one
at a time until the culprit is found.

Vaya con Dios,
Chuck, CABGx3



"Delbert" wrote in message
...
The only common set on these files are their macros imbedded. Other than

that
all of their settings and format are different. We've also tried changing
their macro settings from it's original excel files and had the author of
these files do this for us - still error exist.

Thanks.

"CLR" wrote:

Is there anything in common with the files that cause the

problems?.....such
as a similar format, same macros, etc etc?

Vaya con Dios,
Chuck, CABGx3


"Delbert" wrote in message
...
Thanks for your input but all these are not rectifiable since I have

opened
the very same files that they are having problems with into another

system
and it work fine. They can somehow open other excel spreasheets fine

on
the
very same network folder where the problematic files are located so

it's
telling us that it has nothing to do with the network/directory. I

appreciate
the response though....


"CLR" wrote:

Isolate the problem as best you can...........separate the Network

from
the
Files from the Computers..........move the files about on Jump

Drives to
help
with this........list specific arrangements where the problem exists

and
where it don't......may be a bad leg on the Net, or

directory..........

hth
Vaya con Dios,
Chuck, CABGx3



"Delbert" wrote:

Multiple users here have this same problem that whenever they open

a
particular Excel file, it gives them a "Send Report Error." Weird

thing about
it is it doesnt
happen in all their Excel files, only happens to some of them.

Also
tried
opening
the very same file/s they are having problems with on my machine

and
it worked
fine.
I have patched Office (SP2), updated Acrobat Reader, updated

signatures,
uninstalled/reinstalled Office, and done all the possible

troubleshooting on
these machines but still error occurs.

Any help appreciated, thanks!






  #8   Report Post  
Old December 12th 05, 11:41 PM posted to microsoft.public.excel.misc
Delbert
 
Posts: n/a
Default Excel Crash - Help!

Thanks for your input Dave P. - I have tried your suggestions just now and
still the error occurs. All addins are disabled but still did not rectify
this issue. Also checked for xlb's but none found on the system. I already
tried detect/repair and reinstalled excel but those didnt help either. It's
not a corruption with these files since other users can open it on another pc
nor a corrupted system since they can open other excel sheets just fine. I've
also updated into the latest patch SP2 for their office but also no luck!

I have made a temp workaround for these folks and had copied the very same
file into that same path, renamed it and so far it's working for them.

But I'm afraid that these copied files might fail also in the future. Any
other ideas? I am stomped!



"Dave Peterson" wrote:

Can you try this on the problem pc's?

Close excel
windows start button|Run
excel /safe
(hit enter)

Starting excel in safe mode disables lots of stuff (macros/addins/toolbars).

Then File|open the workbook

If excel crashes, maybe it's one of those addins/toolbars.

You can disable the addins that are in your XLStart folder and Tools|Addins to
start.

Chip Pearson has some notes on how to diagnose startup errors at:
http://www.cpearson.com/excel/StartupErrors.htm

And Jan Karel Pieterse has more notes at:
http://www.jkp-ads.com/Articles/StartupProblems.htm

====
You could see if its the toolbar file, by:
close excel
windows search
search for *.xlb
(in hidden folders for hidden files, too)

Rename all the *.xlb files you find to *.xlbOLD

Then restart excel and see if that helps.

If it does, then rebuild any customized changes to the toolbar at your
convenience.

If it doesn't, then close excel and rename all those *.xlbOLD back to *.xlb.

====

And since it's only happening on a few (assuming the same version of excel),
maybe you can use:
help|detect and repair (if that's available in your version)

or even reinstalling excel on those pc's would help.


Delbert wrote:

The only common set on these files are their macros imbedded. Other than that
all of their settings and format are different. We've also tried changing
their macro settings from it's original excel files and had the author of
these files do this for us - still error exist.

Thanks.

"CLR" wrote:

Is there anything in common with the files that cause the problems?.....such
as a similar format, same macros, etc etc?

Vaya con Dios,
Chuck, CABGx3


"Delbert" wrote in message
...
Thanks for your input but all these are not rectifiable since I have
opened
the very same files that they are having problems with into another system
and it work fine. They can somehow open other excel spreasheets fine on
the
very same network folder where the problematic files are located so it's
telling us that it has nothing to do with the network/directory. I
appreciate
the response though....


"CLR" wrote:

Isolate the problem as best you can...........separate the Network from
the
Files from the Computers..........move the files about on Jump Drives to
help
with this........list specific arrangements where the problem exists and
where it don't......may be a bad leg on the Net, or directory..........

hth
Vaya con Dios,
Chuck, CABGx3



"Delbert" wrote:

Multiple users here have this same problem that whenever they open a
particular Excel file, it gives them a "Send Report Error." Weird
thing about
it is it doesnt
happen in all their Excel files, only happens to some of them. Also
tried
opening
the very same file/s they are having problems with on my machine and
it worked
fine.
I have patched Office (SP2), updated Acrobat Reader, updated
signatures,
uninstalled/reinstalled Office, and done all the possible
troubleshooting on
these machines but still error occurs.

Any help appreciated, thanks!





--

Dave Peterson

  #9   Report Post  
Old December 12th 05, 11:46 PM posted to microsoft.public.excel.misc
Delbert
 
Posts: n/a
Default Excel Crash - Help!

When I open these files and answered to the prompt where it questioned me if
I want to update links - per user they normally click on "Dont Update" and it
worked that way - it then crashes right away. Excel is not asking me to
disable/enable the macros at startup so I'm not sure which option are you
referring to?

Thanks.

"CLR" wrote:

Maybe with security setting high, try to open one of the errant files
without enabling the macros....just to see if that can be identified as
where the problem is.....if so, then the macros can be enabled/disabled one
at a time until the culprit is found.

Vaya con Dios,
Chuck, CABGx3



"Delbert" wrote in message
...
The only common set on these files are their macros imbedded. Other than

that
all of their settings and format are different. We've also tried changing
their macro settings from it's original excel files and had the author of
these files do this for us - still error exist.

Thanks.

"CLR" wrote:

Is there anything in common with the files that cause the

problems?.....such
as a similar format, same macros, etc etc?

Vaya con Dios,
Chuck, CABGx3


"Delbert" wrote in message
...
Thanks for your input but all these are not rectifiable since I have
opened
the very same files that they are having problems with into another

system
and it work fine. They can somehow open other excel spreasheets fine

on
the
very same network folder where the problematic files are located so

it's
telling us that it has nothing to do with the network/directory. I
appreciate
the response though....


"CLR" wrote:

Isolate the problem as best you can...........separate the Network

from
the
Files from the Computers..........move the files about on Jump

Drives to
help
with this........list specific arrangements where the problem exists

and
where it don't......may be a bad leg on the Net, or

directory..........

hth
Vaya con Dios,
Chuck, CABGx3



"Delbert" wrote:

Multiple users here have this same problem that whenever they open

a
particular Excel file, it gives them a "Send Report Error." Weird
thing about
it is it doesnt
happen in all their Excel files, only happens to some of them.

Also
tried
opening
the very same file/s they are having problems with on my machine

and
it worked
fine.
I have patched Office (SP2), updated Acrobat Reader, updated
signatures,
uninstalled/reinstalled Office, and done all the possible
troubleshooting on
these machines but still error occurs.

Any help appreciated, thanks!







  #10   Report Post  
Old December 13th 05, 12:00 AM posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default Excel Crash - Help!

You must first re-set your security setting on one of the machines having
toruble.........it varies depending on which version of Excel you're
using......in XL97, it's Tools Options GeneralTab uncheck "Macro virus
protection".....in others I think it's Tools Macro Security......

Also, is there any commonality of Excel Version numbers on the good/bad
machines, and/or AntiVirus software?

Vaya con Dios,
Chuck, CABGx3




"Delbert" wrote in message
...
When I open these files and answered to the prompt where it questioned me

if
I want to update links - per user they normally click on "Dont Update" and

it
worked that way - it then crashes right away. Excel is not asking me to
disable/enable the macros at startup so I'm not sure which option are you
referring to?

Thanks.

"CLR" wrote:

Maybe with security setting high, try to open one of the errant files
without enabling the macros....just to see if that can be identified as
where the problem is.....if so, then the macros can be enabled/disabled

one
at a time until the culprit is found.

Vaya con Dios,
Chuck, CABGx3



"Delbert" wrote in message
...
The only common set on these files are their macros imbedded. Other

than
that
all of their settings and format are different. We've also tried

changing
their macro settings from it's original excel files and had the author

of
these files do this for us - still error exist.

Thanks.

"CLR" wrote:

Is there anything in common with the files that cause the

problems?.....such
as a similar format, same macros, etc etc?

Vaya con Dios,
Chuck, CABGx3


"Delbert" wrote in message
...
Thanks for your input but all these are not rectifiable since I

have
opened
the very same files that they are having problems with into

another
system
and it work fine. They can somehow open other excel spreasheets

fine
on
the
very same network folder where the problematic files are located

so
it's
telling us that it has nothing to do with the network/directory. I
appreciate
the response though....


"CLR" wrote:

Isolate the problem as best you can...........separate the

Network
from
the
Files from the Computers..........move the files about on Jump

Drives to
help
with this........list specific arrangements where the problem

exists
and
where it don't......may be a bad leg on the Net, or

directory..........

hth
Vaya con Dios,
Chuck, CABGx3



"Delbert" wrote:

Multiple users here have this same problem that whenever they

open
a
particular Excel file, it gives them a "Send Report Error."

Weird
thing about
it is it doesnt
happen in all their Excel files, only happens to some of them.

Also
tried
opening
the very same file/s they are having problems with on my

machine
and
it worked
fine.
I have patched Office (SP2), updated Acrobat Reader, updated
signatures,
uninstalled/reinstalled Office, and done all the possible
troubleshooting on
these machines but still error occurs.

Any help appreciated, thanks!











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
convert pocket excel back to standard excel kevroyal Excel Discussion (Misc queries) 1 February 16th 06 11:35 AM
unhide menu bar in excel - just disappeared Sean Setting up and Configuration of Excel 11 December 4th 05 08:01 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Excel startup switches Randy Excel Discussion (Misc queries) 9 June 14th 05 10:27 PM
Path\File name length problem Excel Crash on save as Datasort Excel Discussion (Misc queries) 0 April 8th 05 05:19 PM


All times are GMT +1. The time now is 09:56 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017