2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Excel on Android opens old version of file

I have a number of Excel files saved on my Google Drive. I'll update them using a laptop.

On my phone, I open Google Drive. I see that they all have the correct date and time from the last save. If I click the three dots, and pick "open with," the Excel app on my phone opens, but it pulls up the prior version of the file! It doesn't matter how long I wait to do this.

If I open the file into Google Sheets (from my phone), it is always the most recent version. If I look at "view information" I get a tiny thumbnail of the file, and I can see it's the most recent version. So the problem isn't with Google Drive. I've tried making the file available offline (to force an immediate download of the recent version to my phone's storage) and this doesn't help.

After the old version opens into Excel, I need to close the file (with "discard changes"), close the Excel app on the phone, and reopen the file from Google Drive, then I'll get the most recent version. Why is this happening?

And clearly, having to "clear a cache" every single time is a non-solution. I'm not going to go to Apps, Excel, Data, Clear Cache every time I want to look at a file.

submitted by /u/tbartman
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#Excel compatibility
#google sheets
#real-time data collaboration
#financial modeling with spreadsheets
#rows.com
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#intelligent data visualization
#Excel
#Android
#Google Drive
#file version
#recent version
#old version
#open with
#Google Sheets
#discard changes
#cache