Excel 2003 Copy Sheet crash

[GlennUK]

Hi all,

one of my users has just upgraded to Excel 2003, and one of her books has suddenly started crashing Excel whenever you try to copy any sheet within the workbook.

I've spent 45 minutes trawling through the Microsoft site, to see if there are any articles regarding this problem, without any luck so far. So thought I'd ask here as well.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[KenWright]

Firstly Try 'Open and Repair' and see if that fixes it.

Then try saving the file as a .htm file and than back to a .xls file and see if that gets rid of the corruption.

Regards
Ken..............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[GlennUK]

Hi Ken,

no, the Open and Repair doesn't fix it.

What features are lost when saving as .htm? The book contains external links, a pivottable and many calculations, and embedded buttons, and VBA. ( haven't been able to get on the machine to try the .htm save trick yet, as there is reporting to produce today, and getting that out is highest priority, and some work arounds seem to be working )

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[KenWright]

Just tried with a test file in 2003 with all those things in and Round Tripping via html didn't lose anything.

If Round Tripping in 2003 doesn't do it then try Round Tripping in Excel XP as well, as I have seen reports where one worked and one didn't - Go figure.

Regards
Ken..............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[GlennUK]

Hi Ken,

thanks for the help. Just managed to try Round Tripping via html, but it didn't fix the problem. Will see if anyone here has Excel XP to try the same thing on that.



Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[KenWright]

Don't know how sensitive it is but happy to give it a go for you if you can't find a copy. Let me know if you want me to and I'll give you the addy over in TTUK.

Regards
Ken..........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[GlennUK]

Thanks Ken,

if it's necessary I'd really appreciate that. Am waiting to see what the user says.



Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[KenWright]

Glenn, have posted my details there anyway. Will be around for probably another 1 1/2 hours or so.

Regards
Ken..............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[GlennUK]

Thanks for the offer. We are all giving up for today ... Excel just crashed again doing something else.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[GlennUK]

Hi Ken,

it looks like we have found the cause. The sheet that causes the crash when attempting to copy it has many external links. The source workbook and the external supporting files are all on a network. Copying all the files involved onto the C: drive and trying again ended with success.

So, with a bit of process redesign ( opening the supporting files before doing any other processing ), we have everything working as required.

The surprising thing is that this workbook worked on Excel 97 ( and has been working fine in many incarnations for a long time ), but crashed Excel itself when being used on Excel 2003.

Many thanks again for the hints, and offers of help.


Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[KenWright]

No problem, and any time

Regards
Ken............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------