cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tofsweden
Helper II
Helper II

Excel in Onedrive, can't write file to souce

Hello, 

I've an issue with an excel table that powerapps still insist it's locked. So far I've been trying troubleshooting by;

 

1. Format table

2. Ensure there are no formulas and all data is raw

3. Check that table or so is NOT protected

4. right-click file and check if its writeprotected and it is not

 

I am running out of options, with what might be faulty. So I need second opinion from someone else that can try reproduce error.

 

link to excel: https://1drv.ms/x/s!AsVCpXcMv2bqgR-bNt7hQaJ9QegW

 

 

 

EDIT: Magically it started to work, after 4 hours of troubleshooting. I didn't do anything and then it just started to work. However that might be an issue, that files are said to be locked and after random hours it is not anymore.

20 REPLIES 20
JasonE
New Member

I ran into the same issue this morning.

You or someone else has the excel file open in Excel, or another viewer.

Close it, and poof - problem solved.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (1,812)