+ Reply to Thread
Results 1 to 3 of 3

Excel files not opening correctly in newly installed office 2010 (VBA part being removed)

  1. #1
    Registered User
    Join Date
    02-09-2013
    Location
    europe
    MS-Off Ver
    Excel 2010
    Posts
    2

    Excel files not opening correctly in newly installed office 2010 (VBA part being removed)

    Hi,

    I just installed and registered Ms Office 2010 pro (v14.0.6023.1000, 32-bit) on a Windows 8 Pro machine.
    When I try to open an .xlsm file excel gives me the message:
    "Excel found unreadable content in ... Do you want to recover the contents of this workbook? If you trust the source of this workbook click yes."
    When I click yes excel shows the next message:
    "Excel was able to open the file by repairing or removing the unreadable content... removed part /xl/vbaproject.bin part."
    The file is now open, but my VBA macros are gone, so the file is useless to me??

    The file is completely ok, I just saved that xlsm on another machine with office 2010, and everything is working fine there...

    I have this with every file that I open, apart from a file that I created with this excel install.

    I already checked this office installation (even did a repair): VBA is installed and works. I can create new xlsm files with working macros.

    How can I solve this problem?

    some additional information:
    before I installed this new office 2010 pro I installed and removed an other office 2010 as temporary solution. But as said: I removed this install before downloading and installing this new office 2010.
    In that previous office 2010 install everything worked fine.

    Regards,
    B

  2. #2
    Forum Contributor dogberry's Avatar
    Join Date
    07-15-2012
    Location
    Wales, UK
    MS-Off Ver
    Excel 2010
    Posts
    624

    Re: Excel files not opening correctly in newly installed office 2010 (VBA part being remov

    Hi

    A strange one indeed do any of your files open ok but in compatability mode first and if so have you tried a save as give a different name and then see if file opens properly.


    Chris
    Click my star if I helped Thanks

  3. #3
    Registered User
    Join Date
    02-09-2013
    Location
    europe
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Excel files not opening correctly in newly installed office 2010 (VBA part being remov

    I have this issue with all xlsm file I try to open, except the xlsm files that I generated with this particular excel install.So I cant even open in compatibility mode.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1