Forum Discussion
Solved
Excel file schedule refresh problem
I have an excel file on sharepoint to use in reports. When I want to scheduling I got this type of error. What can I do for this error?
Is your connection string using a mapped drive letter (e.g. W:\MyFile.xlsx)?
If so this won't work, you'll need to use a UNC path (e.g. \\MyServer\MyFile.xlsx).
Glad you got over the first issue.
The error you're now seeing looks like a permissions issue. Can you confirm the credentials you are using to read the Excel file have the correct permissions assigned?
Actually I tried a lot of time for refreshing, but everytime I got this error. My report uses bot the excel file and sharepoint lists. The error message is related to the sharepoint lists. Sometimes I got the same error for the excel file.
The excel file have no login need to connect, but authentication for the file folder is given in the authentication part as Windows account.