Forum Discussion
New "Automate" tab in Everybody's Excel Online Except Mine
Hello, I had the Office Admin turn on the Office Scripts feature in Excel and it is working in everybody's Excel Online except for my computer. I thought maybe if I removed all my Office Add-Ins ...
- There are two possible fixes for this:
1. Clear out your cookies
2. Enable third party cookies (this one is mandatory for the Automate tab to appear I'm afraid)
SergeiBaklan yes agreed. Trying to move away from Task Scheduler refreshes of Power Query + VBA though, and we have some use cases where Excel beats Power BI still, so really hoping automated refresh comes to Excel online.
If under automated refresh you mean scheduled one, Power BI workspace could be an option. Add data returned by Power Query to data model, connect to workspace, schedule refresh and forget about this workspace, work with Excel as usual. The only minus such refresh fails if the file is opened / checked-out by someone.
SergeiBaklan oh right, nice idea. Hadn't thought of that.
