Hi all,
Is it possible to prevent my spreadsheet (.xlsm) from opening on Google Sheets? There are some array formulas and macros in my file that stop working in Excel if the file is opened on Google Sheets (even in Preview mode).
I would like to prevent my colleagues from accidentally opening the file on Google Sheets.
Solution: Making sure that the file is only downloadable.
Any help is greatly appreciated! Thank you
Try saving it as .xlsb instead. Google sheets doesn't seem to be able to open that format - at least at the moment.
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
Thank you very much! This works.Originally Posted by Aardigspook
You're welcome, glad to be of help. Thanks for the rep and for marking the thread as Solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks