In case of having multiple workbooks open it very regularly occurs that editing or copy pasting is not possible.
For example, when I wish to paste data from one workbook into another workbook, that workbook can not be edited - it is in read only mode then.
I can click anywhere, nothing works, I can't even select a cell. The mouse is blocked.
The workaround I have been using so far is to just click on 'Save' within any or the open workbooks.
Then continue with what I wanted to do.
This has been so for already a long time, also with previous Excel version. Currently using Office 365.
Whilst this 'just one click-workaround' works fine, i I still wonder why this is.
Note: there is personal.xlsb in the \start folder.
Any suggestions?
Thanks.
For example, when I wish to paste data from one workbook into another workbook, that workbook can not be edited - it is in read only mode then.
I can click anywhere, nothing works, I can't even select a cell. The mouse is blocked.
The workaround I have been using so far is to just click on 'Save' within any or the open workbooks.
Then continue with what I wanted to do.
This has been so for already a long time, also with previous Excel version. Currently using Office 365.
Whilst this 'just one click-workaround' works fine, i I still wonder why this is.
Note: there is personal.xlsb in the \start folder.
Any suggestions?
Thanks.