Unable to add/edit/delete row in table - Permission issue

AppSheet AppSheet Q&A
1

I get this error message when i try to add to my table, which has the source of a .xlsx file on onedrive: “Unable to add/edit/delete row in table ‘Indstillinger’. → You do not have permission to access one or more tables in the app. Please contact the app creator to troubleshoot this problem.”

Adds to the table are allowed, and the columns i’m adding to have ‘SHOW’, ‘EDITABLE’, and ‘REQUIRED’ enabled. Clicking ‘View Source’ takes me directly to the onedrive .xlsx file, which anyone with the link can edit. I’ve tried a bunch of the suggestions given to people previously asking this question, but none have been working.

Hope someone can help me with this :))

1 Like
2

2X_c_cb273532ed21cd9357bedf12f30c6944891fbc57.png
2X_c_cb273532ed21cd9357bedf12f30c6944891fbc57.png834×563 40.5 KB

3

Thanks for answering, both as app creator and app user, the same error still shows.

2X_b_bfad372822c442ffa385cd6ea6a17ae60d3f958d.jpeg
2X_b_bfad372822c442ffa385cd6ea6a17ae60d3f958d.jpeg1721×825 237 KB

1 Like
4

Are there any messages in the Info >> Errors tab of the app editor?

5

No

6

I recommend you contact support@appsheet.com directly for help with this.

7

For others… the Excel file was opened in another tab.

3 Likes
8

Hi, I had the same issue and whats the best way to overcome this ? We need to keep the other excel file open while building the application. Is there any solution to make this work ? Thanks.

9

@Rifadm817 As far as I have understood it correctly how Excel365 works, there is no workaround as it closes the connection.

2 Likes
10

Thanks @Aleksi

11

this the same problem i am having.

12

Mornings

This is the same problem i am having, did you manage to fix?

1 Like
13

Any update yet?