Grouped sheets crashes xl2000

[Simon Murphy]

On a corporate network they have xl 2000 sp1 on win 2000
A user keeps getting corrupt workbooks, he has narrowed it
down to whenever he saves a file with more than 1 sheet
selected.
The workbooks open and save fine in XP and 2003 but will
not open in 2000, they always crash it (even after
reparing in 2003)
The only solution I have come up with is opening the file
in 2003 and rebuilding all the sheets and code into a new
workbook.
Looking in the vba ide there always seems to be a spare
Excel object, with no sheet associated, that has similar
properties to the 'thisWorkbook' object.

Has anyone else had the same problem and are there any
better fixes?

cheers
Simon

 

[Rob Bovey]

Hi Simon,

If the *only* time this user experiences file corruption is when he
saves a file with multiple sheets selected then my best advice would be
don't do that! <g> I'm a bit suspicious about this, however, because I've
got a machine running Excel 2000 SR1 on Windows 2000 here and it saves
workbooks with multiple sheets selected without causing any problems. More
likely there's something gone wrong with that user's installation of Office.
Wiping it clean and reinstalling may be the better option.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

 

[Simon Murphy]

Rob
Thanks for replying (and confirming your setup works
fine). It is not just this users set up, my login crashes
these files too.
Any time multiple sheets are selected the file cannot be
opened on the network, he does have other crashes too.
Possibly to do with working from a WAN?
I have given him some before_save code, I just wondered if
anyone else had seen it.
It sounds like an issue with the set up here

Thanks
Simon

 

[Simon Murphy]

Rob
Thanks for replying (and confirming your setup works
fine). It is not just this users set up, my login crashes
these files too.
Any time multiple sheets are selected the file cannot be
opened on the network, he does have other crashes too.
Possibly to do with working from a WAN?
I have given him some before_save code, I just wondered if
anyone else had seen it.
It sounds like an issue with the set up here

Thanks
Simon