Google drive vs onedrive

[Cannone_Cannone]

Hi everyone!!! On business decisions, I should move all my apps from google drive to One drive. I’m trying to use an app that now runs on an online excel sheet in one drive.
Unfortunately, I immediately realized that synchronization is really slow, not so much when I add data but when I delete a table and then re-enter data about 40 rows and 10 columns.
I do this process every day.
Are there any solutions to speed up synchronization?
Thank you all

[SkrOYC]

Can you elaborate what do you mean by “slow”
What are you doing?
From inside or outside your apps?

[Cannone_Cannone]

Thank you
In practice, in an excel file I have a data table of about 40 rows and 10 columns
I created a script, which at 01:00 am deletes this data for me to update by copy and paste the next day.
With google sheet as soon as I synchronized the APP that read the table immediately updated me the new data.
With excel onedrive When it updates in the morning The o app takes a long time to display the new data.

[SkrOYC]

Why not Security Filters btw?

[Steve]

Changes to a Google Sheets spreadsheet are saved as you make them: as soon as a change is saved, it is available to AppSheet. With Excel, the changes you make to the spreadsheet are available to AppSheet only after you close the spreadsheet.

[SkrOYC · Accepted solution]

Google Sheet is an online service.
Microsoft Excel is syncronized with the cloud after changes are made.
Office 365 has this automatically, others don’t.

I use excel and I don’t have problems as long as I don’t open the excel while changes are being made to the DB from AppSheet.

help.appsheet.com

Using Data from Excel spreadsheets in Office 365 and SharePoint

How you can build an AppSheet app with data from Office 365, Excel, and Sharepoint.

With Office 365, if a user has the spreadsheet open for editing, other users and third-party apps like AppSheet can’t make updates to the spreadsheet. Consequently, if you intend to build an app that updates the data (as most apps do!), please make sure to close the spreadsheet first. Otherwise, you’ll see conflict (“409”) error messages and the app won’t be able to save changes to the spreadsheet.

You should be aware that the excel is a file that can be saved on any drive (remember, GSheet is fundamentally different) and the info that is saved inside the file depends on the cloud service, OneDrive for example.
So you have to wait for OneDrive to update your file (from the cloud and to the cloud).

In other words, don’t touch your excel. I just use mine as a datasource for PowerBI.
If you have to make changes to it, do it manually (not macros) and when nobody is using the app. Also make sure OneDrive updates the file to the cloud.

This may sound like a lot of mess. From my POV it’s just a best practice to leave my files alone and maximize all interactions from AppSheet, not Excel

[Madhav_More]

When syncing is going on in the app is your excel file is also open in a new tab?

Getting error or too long to sync the app if data source is excel Questions

I made an app and swapped the data source to an identical excel sheet. The app is able to read that data but whenever a new entry is made it throws an error upon syncing or just takes too long to load. This happens only if the excel data is also open in another tab. Anyone encounter this before? [Screenshot 2021-12-09 at 4.21.56 PM]

[Cannone_Cannone]

hello!!
the excel file is not open in another part.

[Cannone_Cannone]

thanks a lot!!