Forum Discussion
Downloaded Excel template files can't be edited. Clicking Enable Editing is opening a blank workbook
Hi All, Myself and my colleagues at work are having an issue with editing downloaded Template Excel worksheets. The Excel worksheet is just closed after clicking the 'Enable edit' option an...
shoaib2000 Which templates? What excel version? Platform (PC, Mac, On-line)?
I am having this issue as well starting last Friday.
Windows 11, Office 365 latest version, updates applied to both Windows and office. For me, the files are custom templates I created for instruction, which I regularly update, and they have been stored on and downloaded from Microsoft OneDrive. I have also had trouble after emailing the same files. My students seem to be encountering the same issue at different times (eg. Some of them started experiencing the issue Friday, some Monday, I had problems starting Tuesday..)
We are not on the same network.
For us, Excel bogs down after hitting enable editing - we have to force quit Excel. The original file doesn't disappear. It doesn't become editable though, and a new blank file opens instead in front.
I believe all the files have protected sheets which include instructions on how to use the file so that may be a factor. These are files I have used slightly tweaked versions of for at least a year and this behaviour is new.
I have found that if I right-click on the file properties in file Explorer, and click "Unblock" the file will open without having to Enable editing so this is a workaround, but it is not as intuitive.
Apologies if I am interfering in this thread. I'm new to this.
Windows 11, Office 365 latest version, updates applied to both Windows and office. For me, the files are custom templates I created for instruction, which I regularly update, and they have been stored on and downloaded from Microsoft OneDrive. I have also had trouble after emailing the same files. My students seem to be encountering the same issue at different times (eg. Some of them started experiencing the issue Friday, some Monday, I had problems starting Tuesday..)
We are not on the same network.
For us, Excel bogs down after hitting enable editing - we have to force quit Excel. The original file doesn't disappear. It doesn't become editable though, and a new blank file opens instead in front.
I believe all the files have protected sheets which include instructions on how to use the file so that may be a factor. These are files I have used slightly tweaked versions of for at least a year and this behaviour is new.
I have found that if I right-click on the file properties in file Explorer, and click "Unblock" the file will open without having to Enable editing so this is a workaround, but it is not as intuitive.
Apologies if I am interfering in this thread. I'm new to this.
- I am having the same issue. I regularly create templates for our employees to use and store them on G Suite. Starting this weekend, employees were unable to open them without the above happening. Thank you ThomasW2022, at least we can keep everyone working until a better option comes up.
KnotMyTime Has anyone found a solution for this? My worksheets are not protected, but my team cannot access templates without copying to a local disk. Same issue as others, if "Enable Editing" is selected, a blank workbook is created each time it is pressed, but you cannot edit the template.
