Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Saving Excel in Google Drive

0

Hi all,

I need to save my Excel spreadsheets to Google Drive for sharing. 

This is my first time using Google Drive and I noticed that Excel files save as Google Sheet, which is not really Excel, but an Excel look alike, as far as I can tell...

As a result, the interactive elements (spinners) I have included in my files get wiped out, rendering the spreadsheets useless. 

Is there a way round this? Can Excel files be saved as Excel files in Google Drive and not as Google Sheets?

Thank you.

excel
posted by: Zico (rep: 2) on Mon Aug 22, 2022 at 10:39 am
Answer
Discuss

Answers

0
Selected Answer

Zico

I think you need to do 1 or 2 things- in Google Drive, go to Settings (top right) then General. Make sure the item "Convert uploads" is NOT checked (/ticked)- that should stop the file being converted on Upload. Other people should be able to download your original .xls* file,

Then you might like to go  Settings/ Manage Apps and uncheck "Use by Default" against Google Docs. Then an xls* file will display in Google Drive (and have a green marker showing the file extension).

If this works, please remember to mark the Answer as Selected.

posted by: John_Ru (rep: 6142) on Mon Aug 22, 2022 at 12:12 pm
Discuss

Discussion

Many thanks again, John. 

I unchecked both and then downloaded the files once again but they all appear with xlsx extensions and are as before. Am I missing anything?
Zico (rep: 2) Aug 22, '22 at 12:37 pm
Zico. Do you mean you checked the spinners were there, uploaded the file (after changing the Drive settings) BUT when they were downloaded as .xlsx format, the spinners have gone? (Note if you try to open a file in Drive, it will use Google Sheets to display it).

I made an Excel file with a form spinner then uploaded it. I opened it in Drive (clicking and Drive using Sheets) and when I went (menu) File/Download> Microsoft Excel, it opened up in Excel, complete with a working spinner. Suggest you try that.
John_Ru (rep: 6142) Aug 22, '22 at 1:29 pm
My error. I tried opening it in Google Drive. When downloaded and then opened, it works perfectly!

Many thanks, John. 

Have a great day!
Zico (rep: 2) Aug 22, '22 at 1:45 pm
Good! Thanks for selecting my Answer, Zico
John_Ru (rep: 6142) Aug 22, '22 at 2:00 pm
You are most welcome. Thank you for your assistance, John. 
Zico (rep: 2) Aug 23, '22 at 3:52 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login