Answered

Excel-file not found, using "Get active Exel Worksheet". Only when using One-Drive

(0) Share

Report

Posted on by JazzLewis

Hi,

I'm using Power Automate Desktop. In my flow I'm using a Excel file using the "get active Excel worksheet" action. I do this to read data from an Excel-file stored in an Onedrive location using the %ExcelInstance%. But this gives an error message saying the file cannot be found, like "Excel-document C:\Users\User\OneDrive\... not found".

Before the file was stored on a Dropbox location and there was no problem. Also when I change it back to Dropbox or a local location it works fine.

Is there any known issue when using Onedrive? Can anyone help me solve this issue?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

It could be caused by the auto-sync that OneDrive runs, if you use the OneDrive app to sync a directory from SharePoint/OneDrive to your local system.

I have experienced issues with it, especially when writing to files on OneDrive/SharePoint. Reading usually works fine. But if you struggle to do it, it might make sense to try to copy the file locally to your machine first (using Copy file(s)) and then open and read the local copy. If you also modify your file, too (write to it), then you'd need to move it back to the OneDrive directory after making the modifications.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
JazzLewis 15 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the quick response! This will be my go to solution for now.

Was this reply helpful? Yes No