Forum Discussion
Refresh PowerPivot while source file is open
Hi everybody, I have a PowerPivot model (in excel) importing several excel files form a folder. When I'm trying to refresh the PowerPivot while one of the source files is open, I get the following ...
hi, AlexTaskar
The error message is pretty clear: you're trying to access a file, and it's not accessible because another process (or even the same process) is doing something with it.
Please close the source file and refresh again.
Best Regards,
Lin
I'm having the same problem and the file is definitely not in use. All files are in One Drive and closed. Deleted the dataset in Service and reset from Desktop. Refreshed from Desktop. Checked credentials. What's left?