Forum Discussion

huskereurocat's avatar
huskereurocat
Copper Contributor
Jul 11, 2023

Using Personal Workbook Macro in Excel online?

I'm just trying to see if this functionality is even possible in Excel on the web. I have Excel and have created a personal.xlsb file that opens each time I open excel on my PC, but I have a friend t...
excel
Excel for web
Macros and VBA
huskereurocat's avatar
huskereurocat
Copper Contributor
Jul 11, 2023
I'm confused. How do I open my personal.xlsb in Excel online? I'm only seeing workbooks that I have created in Excel online and are now saved to One Drive.
H2O's avatar
H2O
Iron Contributor
Jul 11, 2023
To open a personal workbook in Excel online, the user needs to upload it to OneDrive. A personal workbook is usually stored in a folder called XLSTART on the user's computer. To access it from Excel online, the user needs to upload it to OneDrive and then open it from there. However, the macros in the personal workbook will not run in Excel online.
There are online tools that can open XLSB files .XLSB files are binary files that store Excel workbooks, including personal workbooks. There are some online tools that can open XLSB files for free, such as Aspose.Cells Excel Viewer. However, these tools may not support all the features or functions of Excel, and the macros in the personal workbook may not run either. Open XLSB Online for Free - Aspose. https://products.aspose.app/cells/viewer/xlsb.
  • huskereurocat's avatar
    huskereurocat
    Copper Contributor
    Jul 11, 2023
    First of all I want to thank you for all your help! I have successfully opened my personal.xlsb file in Excel online, but I see no Automate Tab, which is the second step in using Office Scripts.
    I did a little research on the internet and find that this feature needs to be turned on by an account admin and it seems that I can't be an admin unless I purchase the 365 program from Microsoft. Do you know this to be the case? If it is right, then do you know of an alternate plan of attack?

Resources