Hi there, I got a mystery for you:
At my new job they use an excel file which has basically one sheet where we copy and paste data in and then a bunch of sheets which produce charts and a document which incorporates and calculates all this data into a 'story' for our clients.
As they kept on telling me; the file doesn't work on Microsoft Excel for Mac and only works on windows computers. I (apple fan) then used Vmware fusion 6 to run windows 7 and office 2011 Excel on my mac, assuming that the file would work as it would on a Windows computer, but no dice; the result is the same as on Microsoft Excel for mac; there is no output.
If I open the file in the "Protected View" the charts still look good, but when I click on 'enable editing' all the links end up not working and the program doesn't work.
Any idea what is actually going on and am I doomed to have a second computer to run this one excel file from??
Hope this all made sense. Thanks in advance for your reply.
At my new job they use an excel file which has basically one sheet where we copy and paste data in and then a bunch of sheets which produce charts and a document which incorporates and calculates all this data into a 'story' for our clients.
As they kept on telling me; the file doesn't work on Microsoft Excel for Mac and only works on windows computers. I (apple fan) then used Vmware fusion 6 to run windows 7 and office 2011 Excel on my mac, assuming that the file would work as it would on a Windows computer, but no dice; the result is the same as on Microsoft Excel for mac; there is no output.
If I open the file in the "Protected View" the charts still look good, but when I click on 'enable editing' all the links end up not working and the program doesn't work.
Any idea what is actually going on and am I doomed to have a second computer to run this one excel file from??
Hope this all made sense. Thanks in advance for your reply.