Excel Problems - XP vs. Vista

Microsoft Office excel 2003
September 7, 2010 at 01:19:51
Specs: Windows XP, 2 gig
My problem is this. I have an excel spreadsheet which I recently updated on Vista and it worked fine. Previously I had always updated it on another XP machine. When I copied the file back to the XP machine I got the following error: "Compile Error in Hidden Module - Mod General". Mod General is one of my VB sheets. In the past I also got this message on my XP machine but when I copied "pluginn.ocx into Windows/system32" everything was fine. So i did that again but it did not fix it. Can anyone help me solve my problem? I have done the usual deleting of PDFMaker with no result. So to summarise, I updated on Vista and copied te file back to XP but the file would not open due to the compile error. Any help would be much appreciated.
Thanks, Ken

See More: Excel Problems - XP vs. Vista

September 7, 2010 at 04:07:30

When posting in a Help forum such as this, please try to use a Subject Line that is relevant to the content of your post.

If everyone used a generic subject line such as "Help with Excel", we wouldn't be able to tell one question from another. It would also make searching the Archives much more difficult.

I have edited the Subject Line for this thread.

Office Forum Moderator

Report •

September 7, 2010 at 07:20:59
Don't know what version Excel your running, if 2007 try running a Diagnostic,

Running Microsoft Office Diagnostics from within Excel

Click the Microsoft Office button
Click on the Excel Options button to bring up the Excel Options dialog box
Click on the Resources button in the left hand pane
Click on the Diagnose button in the right hand pane
Click Continue
Click Run Diagnostics

Running Microsoft Office Diagnostics from the Start Menu

Click on the Start button
Click All Programs
Click Microsoft Office folder
Click Microsoft Office Tools
Click Microsoft Office Diagnostics
Click Continue
Click Run Diagnostics

if 2003 or 2000 try a Detect & Repair.

On the Task Bar,
Detect & Repair

Also, you can try running without any add-ins or hidden workbooks.

To run Excel without loading add-ins or workbooks from the XLSTART folder use the /Automation switch.

Click Start,
Type in: Excel.exe /Automation

You may need to use the complete path name to Excel.

If that works, go to your add-ins and note which ones you have install, then disable them all but one, then restart with a new one each time till you get the error message.



Report •
Related Solutions

Ask Question