Excel spreadsheets transferred from a Windows PC open in read-only mode

I understand this issue arose over the past 2-3 years, but I haven't seen any solution.

A workbook created on a Windows PC using Office 365 - transferred to Mac (Yosemite installed) - opens in read-only mode in Office 365 for Mac.

The workbook doesn't have a "/" in its name. I made sure there is read/write access for the file and also the folder. It contains macros, some of which work, others will have to be redone.

After saving it with a different name, I may work as usual with it like updating, saving and closing it.

After reopening it, it's again in read-only mode.

After all this time there must be a solution for the problem.
ASPFAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
Were they transferred on a DVD which makes files read only  or on a USB key that does the same thing?
0
ASPFAuthor Commented:
transferred on a removable hard drive, USB connected. It seems to be only macro based files .xlm, some .xlsx but not necessarily all. Especially large workbooks.
0
JohnBusiness Consultant (Owner)Commented:
Make sure hard drive has "Everyone" permissions on both systems and try transferring again. No issue for me on huge files on removable hard drives for Windows only.
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

ASPFAuthor Commented:
The other part of the problem is that once saved under a different name from the read only state, they still open read only.
0
ASPFAuthor Commented:
You have hit the nail on the head, i think. the hard drive is read only and i can't seem to change it to read/write. That said, the issue of saving the spreadsheet to the Mac hard drive then still reopening in read only mode doesn't seem to be solved by this.
0
JohnBusiness Consultant (Owner)Commented:
If the contents can be recovered, then you might consider formatting the drive NTFS on the Windows machine (unless there is a better MAC format).
0
Martin LissOlder than dirtCommented:
What about copying all the sheets to a new workbook?
0
ASPFAuthor Commented:
John, the portable drive is NTFS, I have just changed the permissions on the Windows PC but when reconnecting to the Mac it shows read only and macro based workbooks still open read only, .xlsx workbooks are opening read/write. It appears that there is an inconsistency between the different release levels of Excel (13 on the PC, 11 on the Mac) maybe that is the problem.

Martin, I will give your suggestion a try but it's not a good look for Microsoft and Apple is it.

Thank you both for your thoughts, I am still leaning towards your suggestion John. if only the drive would show read/write. However, these are teething troubles, right?
0
JohnBusiness Consultant (Owner)Commented:
Try formatting the drive exFAT or FAT32 (which was the old DOS format system). This may allow the drive to be read and written by both machines. See this article that provides additional detail.

http://wdc.custhelp.com/app/answers/detail/a_id/291/~/how-to-format-a-wd-external-hard-drive-in-exfat-or-fat32-(to-use-in-windows-or
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ASPFAuthor Commented:
Thanks for your help
0
JohnBusiness Consultant (Owner)Commented:
@ASPF  - You are very welcome and I was happy to help.
0
Tom GrellCOMMUNICATIONS SPECIALISTCommented:
Another possible solution is to install NTFS for Mac® 12 from Paragon Software:
http://www.paragon-software.com/home/ntfs-mac/
which will allow the Mac to read, write and modify files on the NTFS drive without reformatting it. This may clear up the permissions problems that are making the files read only. (I don't currently have the software installed on this computer, so I cannot test it for certain.)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.