Error when trying to use Excel Query

Question

Hello,

I have been using the get data from file tool in excel multiple times for different folders so far and have had no issues. However, when I tried doing the same thing on the next folder I got this error message:

[DataSource.Error] We got the IO error '87' while trying to access the path 'C:\Users\anderson\OneDrive\Proposal\Report'.

If anyone could let me know what the issue might be and how to solve it that would be great.

Answer 1

Hello,

Thank you for your help the version is

(Version 2202 Build 16.0.14931.20648)

I also checked and its trying to open a specific folder but the folder is not open anywhere.

Best,

Julia

Answer 2

Dear Julia_959,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description, please don’t worry, we can work together to narrow down and resolve the situation.

As per your error message, please check your file source path or the file name, you source file might be open and also please check the connection and file path.

May I know does the problem happened do specific document file?

In the meantime, I can’t reproduce the same behaviour as like you described above and to confirm whether this is a bug in a specific version, please provide us the version information. To check version: Open Excel>File>Account>Product Information and capture a full screenshot and share here and we will be tested on that version and verify the result with you.

Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

Sincerely,

Waqas Muhammad