Problem with existing workbook with macros

J

Jonas

We have a number of computers on which we now has installed Excel 2010 and
they were previously running Excel 2007.

On one of these computers we now have problems running a workbook (XLS) that
has macros in them.

The workbook adds some custom options on the addins ribbon tab and this is
where it fails. I've removed this feature and try to run another macro and
get the same error.

The message reads:

"Objektsbiblioteket är ogiltigt eller innehåller referenser till
objektsdefinitioner som inte kunde hittas"

Roughly translated into english, this reads:

"The object library is invalid or contains references to object definitions
that could not be found"

Now, obviously I can't run any macros but I can't save the workbook either.
When I try to save it I get the following message:

"Fel inträffade när C:\Excel\Workbook.xls skulle sparas. Det kan gå att
spara filen om några funktioner tas bort eller repareras. Om du vill utföra
reparationerna i en ny fil klickar du på Fortsätt. Klicka på Avbryt om du
inte vill spara filen."

Translated:

"An error occured when C:\Excel\Workbook.xls was saved. It may be possible
to save the file if a new functions are removed or repaired. Of you want to
preform the repair in a new file, press Continue. Press Cancel if you don't
want to save the file."

I now press "Continue" and get to select a path where to it should be saved.
Then I get this message:

"Fel uppstod när filen sparades. En minimal sparning kunde göras för filen
till C:\Users\JDoe\AppData\Roaming\Microsoft\Excel\XL4A7.xlsb"

Translated

"An error occured when the file was saved. A minimal save could be performed
for the file to C:\Users\JDoe\AppData\Roaming\Microsoft\Excel\XL4A7.xlsb"

Now, all this works fine on everyone elses Excel 2010, no problem what so
ever.

We've uninstalled and reinstalled Office 2010 without any change.

What could be the problem and how do we solve this?

PS, Why aren't there English error messages or at least an error code so
that one could google for others with the same problem!?
 
J

Jonas

Thank you for your reply.

Actually, 2010 is Office14.

I checked this, all the same references are checked on my computer (where it
works) and on the problematic installation.

Also, all the files the references on my computer point to exist on the
problematic computer and I browsed for them manually just in case but it did
no difference.

The same error occurs when opening the workbook.
 
J

Jonas

I perhaps should add that we uninstalled Office 2007 from all computers prior
to installing Office 2010 - if that could matter.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top