3 Replies Latest reply: Aug 24, 2008 1:42 AM by Axel Foley
Sum Ho Level 1 (0 points)
I was told that I could remove the macro in PC before loading up the excel file on Mac, so that I can read the PC excel file in Mac. Do you know how to remove the macro in PC? The steps??

MacBook, Mac OS X (10.5.4)
  • Axel Foley Level 5 (4,005 points)
    Speaking of macros, allow me to get a few things clear.
    1. Excel (Office Version 2004 for Mac) will open Windows Excel files (except 2007) fine with embedded macros.
    2. Excel (Office Version 2008 for Mac) will open Windows Excel Files (All versions) and will ignore the macros and its functionality.

    Bottom line is that if you have the right Mac version opening the Windows version of Excel then in every case it will open the file except macros if using Office for Mac 2008. So, the macros will not function in Office 2007 for mac but the file will still open.

    Axel F.
  • Sum Ho Level 1 (0 points)
    Thanks indeed. I just bought the Mac version of office 2008. When I open the window excel file, it asked me to open, cancel or open and remove Macros. In other word, I should not be asked to remove and it should just do it automatically, shouldn't it??

    And, it did not happen to my other files. Strange!!
  • Axel Foley Level 5 (4,005 points)
    Sum:

    When I open the window excel file, it asked me to open, cancel or open and remove Macros. In other word, I should not be asked to remove and it should just do it automatically, shouldn't it??

    It will ask you every time ONLY IF there are macros embedded in the file. It will either ask you to remove the macros or leave them in but ignore the macros functionality.
    And, it did not happen to my other files. Strange!!

    Not strange because the other files that you had did not have any macros created by the file creator. Remember, the macros options are ONLY shown when there ARE macros in the file.

    Axel F.