I have an Apple, with Office X installed, connected to my network of PC's running Office XP. When I open a Excel file (served from a PC across the network) on the Apple, it opens fine with Excel X and I can do all my edits etc without trouble. However when I save back the file to its original location, it creates a shadow file as well with some meaningless information. The saved file when opened on the PC (Excel XP) has lost its VBA project name (and all modules) and therfore can not perofrm any VBA macros unless these are repasted from elsewhere.
Has anyone any ideas to solve this?