View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Fredrik Wahlgren Fredrik Wahlgren is offline
external usenet poster
 
Posts: 339
Default URGENT: Mac/PC Macro compatibility problem


"marika1981" wrote in message
...
I'm having serious problems opening a macro-rich spreadsheet created on a

Mac
on a PC. The file opens fine on the Mac with Excel 10.1.0, but it crashes
Excel 2000 on a PC upon opening, even if the macros are disabled.

Any ideas?? I'd be eternally grateful, as I'm in DEEP trouble if I don't
solve this problem....

Thank you so much......


One thing that you may want to try is to export the workbook in a piecemeal
fashion. The idea is to open the workbook and the first sheet. Press CTRL+A
to copy it and then open a new document in which you paste it. Save the
workbook with the same name as the sheet. Do this for every sheet in the
workbook. You will end up with as many workbooks as there are sheets in your
original workbook. The macros can be saved in text format

You should then see if each sheet opens. If they all do, you can then
reassemble the original workbook . This should be doable unless you have too
many sheets or if some sheets refers to other sheets.

It may be a good idea to start with one sheet only and see if it opens. It's
quite possible that Excel 2000 on the PC is damaged somehow.

/Fredrik