excel crashing

[buz]

This has happened a few times and has finally become infuriating.

I have XL working for me. A wkbk with a few databases and a few pivottables, all together 12 sheets (a few are practice sheets and one is explanatory for the formulas/functions being used)

Problem is, once in a while, when opening another wkbk which has =GETPIVOTDATA in it, XL vanishes all together. Naturally, any unsaved work is gone. Unsaved work would be database entry/updating.

I am using a Mac G4 450 with OS 10.1.5 and XL2001. Essentially, I am using XL in OSX's classic mode.

Any ideas what may be going on here? The OS se3ems pretty stable with any of my other apps, including PS6, VW9.5, Word 2001, GoLive5, .....

tfyh

Buz

 

[stevebausch]

Don't know much about Mac, but if this were PC, I would be thinking along the lines of code that hides the application.

For a PC, that code would involve the word "WindowState".

If you know this code forwards and backwards, but there is nothing hiding the application, you may need to step through the code and see where the disappearing act starts.

 

[buz]

Steve

Thank you - but I don't believe it has anything to do with code. The 'disappearing' I refer to is actually - crashing/quiting on it's own with no warning.

 

[buz]

I reinstalled SR1 update for Office 2001 hoping it could be the difference.

So - no one has experienced this behavior before?

 

[buz]

some one's got to have a clue.

anyone?

 

[Jack in the UK]

Hi Buz

Dont get too exceited i know ZIP about Macs

GETPIVOTDATA

I would say kill the link and see if that solves the issues, when re open, only do this on backed up files not real work just in case

If this is the case then rebuild the pivot, if not post what happens and ill have a brain storm

 

[Juan Pablo González]

buz, is the GETPIVOTDATA function available in Mac ?

 

[buz]

Juan - Yes is it is, have been using it for a few months now.