• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 303
  • Last Modified:

Problems with Excel workbooks

Hi All

I am having some problems with excel workbooks. I have a computer that is having problems opening excel files with macros. Every time it tries to access the file i get the following error message. "Excel found unreadable content in 'file_name.xlsm' Do you want to recover the contents of the workbook?"

If I click yes I then get another error message  stating that "Excel was able to open the file by repairing or removing the unreadable content. Now all the Macros are gone.

Any Ideas?

0
Headmasters
Asked:
Headmasters
1 Solution
 
shareefpkdCommented:
Is it Office 2007? Did you do any upgrade recently?
0
 
viralypatelCommented:
it may be because of links to a file that hasn't existed for a long time. Here is how u can fix it:

When you receive the message error, click Yes. 

When the repair message comes up, click Close.

File -> Option -> Trust Center -> Trust Center Settings -> External Content, 

Change from Prompt to Disable on both settings. Click Ok. 

Open in new window


Save workbook and the error must be gone when reopening it.
0
 
HeadmastersAuthor Commented:
That just stops the error message from displaying, however the macros are all gone. Any ideas how I can keep the macros running?
0
 
Rory ArchibaldCommented:
Can you record macros on that machine? Did you do a full Office install including VBA on it?
0
 
HeadmastersAuthor Commented:
Yep that was it. VB was not installed.

Cheers
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now