Cannot open Excel 2000 file containing PivotTables

[Guest]

I have an issue with what I think is a user profile. At the moment whenever
a particular user attempts to open an excel workbook containing a pivottable,
excel will crash with a general protection fault.
Any other workbook not containing pivottables will open OK.
The user logging onto another workstation in the domain can open the file OK.
An admin user logging onto that machine can open the files OK.

I have repaired, uninstalled and reinstalled office, but the error still
exists. I have deleted the users' profile located on the machine but the
problem still occurs. Are there any hidden, non profile based settings that
could cause this issue?

Thanks for any help in advance.

 

[Jan Karel Pieterse]

Hi Martin,

I have an issue with what I think is a user profile. At the moment whenever
a particular user attempts to open an excel workbook containing a pivottable,
excel will crash with a general protection fault.
Any other workbook not containing pivottables will open OK.
The user logging onto another workstation in the domain can open the file OK.
An admin user logging onto that machine can open the files OK.

Hmm. What about cleaning out the user's Temp folder?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

 

[Guest]

All temp folders are clear - c:\temp and the ones in documents and settings.

Thanks for the idea though

 

[Jan Karel Pieterse]

Hi Martin,

All temp folders are clear - c:\temp and the ones in documents and settings.

Pity. OK, what about the xlb file?

Alternatively, check my startup trouble page:

http://www.jkp-ads.com/Articles/StartupProblems.htm

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

 

[Guest]

Regserver did the trick! It was missing a tbl file that was automatically
installed after the error.

Cheesr

 

[Jan Karel Pieterse]

Hi Martin,

Regserver did the trick!

Great! thanks for letting us know.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com