The title may surprise you, but there really exists a problem with file writability, if you access on a file modified on a PC over Windows Phone 8.1! Actually, the problem first arose under Windows Phone 7.4, but I later switched to a then new smartphone under Windows Phone 8.0, which I later upgraded to Windows Phone 8.1 (it is a NOKIA Lumia 930).
I am using mobile devices to take notes for more than 15 years now. At the beginning, I used Windows CE and later the Windows Mobile 6. With the years passing by, the capabilities of the mobile devices increased, making it possible to enter directly the data into a Microsoft Office document (like Excel) without first making text notices in a TXT file and copying it in another "real" Excel file on the PC later on. But with the above error I am dealing with, I go "back to the old times" and have to copy and paste at home all the notices, if they are meant to be part of an Excel sheet that all-of-a-sudden became read-only.
Actually, I never make the files read-only intentionally. All happens when sometimes adding a column or a new tab when editing the documents over OneDrive in the browser, using Microsoft Excel at home or at business.
I once asked on a site about this problem. One guy – an Excel specialist – told me that the file I attached for scrutiny was including some code that cannot be edited by Windows Phone. So far, so good.
My question is:
- Is it possible to *cleanse* an Excel file from any code that makes it read-only under Windows Phone 8.1 (and perhaps even with Windows 10 for mobile)?
- If not, is it possible to create a copy by using macros etc. such that a new Excel file is being created with a similar name, but the same content (information, field colouring, column width, row height, formulas, tabs etc.)?