Forum Discussion
Solved
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)
Thanks for posting it. I will forward to the technical team.
I also learnt from the product team that we are slowly rolling out the available by default (without having to turn on by default) starting with targeted release users. At this moment while this rollout is in progress, the ability to turn-on by admin is not going to work. If you are not in the target release user base (I think this is picked randomly), you may not be able to access the feature depending on where we are in the rollout process and which audience group you are in. This may sound confusing - but the short answer is within few weeks Automate tab will appear for all users and during this process new users can't turn on by opting in.
Hope that helps.
That's only to wait while it'll be available for your tenant / account.
SergeiBaklan oh right, nice idea. Hadn't thought of that.
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 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.
Power Query refresh doesn't work in Excel Online (hope so far), doesn't matter if you initiate it manually or by script. Workarounds are
- refresh in desktop app
- if data is added to data model, connect file to Power BI workspace and schedule refresh in it. Or refresh manually here, or by Power Automate.
LConstruction mine has shown up. Sadly, I can't find a way to get it to trigger a Power Query refresh!
