Does Office 365 support Excel Macros
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
Does Office 365 support Excel Macros
Does Office 365 support Excel Macros, I'm mixed answers
-
- cheese lizard
- Posts: 6241
- Joined: 16 Jan 2010, 00:14
- Location: Sydney Australia
Re: Does Office 365 support Excel Macros
I'm using Office 365 and it sure does support macros.
Cheers, Claude.
-
- Administrator
- Posts: 78574
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Does Office 365 support Excel Macros
Office 365 is (currently) Office 2013, only as a subscription instead of a one-time purchase. It supports macros exactly the same way as earlier versions of Office.
Microsoft has also created an online version of Office that runs in the browser. If you open an Excel workbook or a Word document in Microsoft OneDrive, in your browser, it will open in the online version of Office. This version does not support macros. But there is an option to open that workbook or document in Office 365, and then macros can run.
Microsoft has also created an online version of Office that runs in the browser. If you open an Excel workbook or a Word document in Microsoft OneDrive, in your browser, it will open in the online version of Office. This version does not support macros. But there is an option to open that workbook or document in Office 365, and then macros can run.
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
Re: Does Office 365 support Excel Macros
The reason why I was asking is this last couple days I had a new client with Office 365 and a previous client who just reformatted his computer getting this message “Excel found unreadable content in ****.xlsm. Do you want to recover the contents of this workbook”. No matter if they say yes or no to repair/remove contents, it still will not open properly.
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
Re: Does Office 365 support Excel Macros
HansV wrote:Office 365 is (currently) Office 2013, only as a subscription instead of a one-time purchase. It supports macros exactly the same way as earlier versions of Office.
Microsoft has also created an online version of Office that runs in the browser. If you open an Excel workbook or a Word document in Microsoft OneDrive, in your browser, it will open in the online version of Office. This version does not support macros. But there is an option to open that workbook or document in Office 365, and then macros can run.
is this a setting in excel options
-
- Administrator
- Posts: 78574
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Does Office 365 support Excel Macros
As far as I know, if you open a workbook in Microsoft OneDrive, it will initially open in Excel Online, but you'll get a warning if the workbook contains macros. You then have the option to open the workbook in Excel 2013 or to download it to a local disk.
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
Re: Does Office 365 support Excel Macros
What about the error message they are receiving (Post=155323)is this something different.
-
- Administrator
- Posts: 78574
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Does Office 365 support Excel Macros
Yes, that error message indicates that the workbook has become corrupted.
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
Re: Does Office 365 support Excel Macros
Even if it works ok on different computers.
-
- Administrator
- Posts: 78574
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Does Office 365 support Excel Macros
If so, I don't understand the error message, sorry.
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
Re: Does Office 365 support Excel Macros
I was reading somewhere that it mentioned a fix this type of error message for this was to install the Visual Basic component, but I'm not sure how or if its the right solution. That's why I come here
-
- Administrator
- Posts: 78574
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Does Office 365 support Excel Macros
I don't know how that works in Office 365. I have the stand-alone version of Office 2013.
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
Re: Does Office 365 support Excel Macros
I’ll try a couple more things such as, verify that all updates for Office and Windows and I’ll check to see if they may have two versions of Office which may cause some conflict.
-
- SilverLounger
- Posts: 1868
- Joined: 25 Jan 2010, 14:00
- Location: Conroe, Texas
Re: Does Office 365 support Excel Macros
UPDATE; As to the two that were having a problem; one it seems was using a rebuilt computer with a pirated Windows 7 and would not update. He now has a new computer and every things works great. The second individual it seems that out of the blue everything started working (miracles do happen ) not sure what caused the error in the first place.
-
- Administrator
- Posts: 78574
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Does Office 365 support Excel Macros
Glad to hear that it's alright now - it was a puzzling problem!
Best wishes,
Hans
Hans