Running a Visual Basic excel sheet on Mac
Discussion
I have Office 2016 for mac and need to run an Excel spreadsheet from work on my mac that originally was written for windows.
I can open it on my mac but can't input the values into the spreadsheet that has been custom built. I don't think the sheet is too complicated in itself, its just designed with a nice UI and is a finance payment calculator - eg money borrowed/term/interest rate inputs cough out the monthly payments and interest rates etc.
Is there any way to get this to run?
At the moment I have to use my Windows lappy to run it and then faff about with printer cables to get it to print instead of my Mac and use an usb stick to copy the quote over to Mac.
Oh, the third world problems of working from home 2 days a week!
I can open it on my mac but can't input the values into the spreadsheet that has been custom built. I don't think the sheet is too complicated in itself, its just designed with a nice UI and is a finance payment calculator - eg money borrowed/term/interest rate inputs cough out the monthly payments and interest rates etc.
Is there any way to get this to run?
At the moment I have to use my Windows lappy to run it and then faff about with printer cables to get it to print instead of my Mac and use an usb stick to copy the quote over to Mac.
Oh, the third world problems of working from home 2 days a week!
Murph7355 said:
Excel 2016 is fine on a Mac, except..... VBA 
I find even large sheets with a couple of pivot tables and macros are painfully slow - especially compared to windows. It's getting to the point I'm considering going back to windows 10. It's not like the MacBook is old either - it's a late 2016 MBP Touch with the 2.7Ghz i7 quad core and 16Gb ram.
andygo said:
I have got parallels installed on my mac now. However my office software is on dvd and my mac doesnt have a dvd drive.
I have copied the Office DVD to an external USB disk drive, but cant find a way for the parallels control centre to install it.
Any ideas folks?
https://kb.parallels.com/en/119310I have copied the Office DVD to an external USB disk drive, but cant find a way for the parallels control centre to install it.
Any ideas folks?
https://kb.wisc.edu/page.php?id=46058
a7x88 said:
Murph7355 said:
Excel 2016 is fine on a Mac, except..... VBA 
I find even large sheets with a couple of pivot tables and macros are painfully slow - especially compared to windows. It's getting to the point I'm considering going back to windows 10. It's not like the MacBook is old either - it's a late 2016 MBP Touch with the 2.7Ghz i7 quad core and 16Gb ram.
Still, Win10 in Pro form is a decent enough OS, so I wouldn't worry about that.
Lenovo's X1 Carbons are excellent machines to go with it. Only real shortfall is no ambient sensor for they keyboard back-light. (A bearable but dumb omission).
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff


