Hi All
My second ever forum post, exciting times! I am using Excel 2010 in Windows 7 on a new work network and have a personal macro workbook. I mention these points because I have been having issues which are related to them. Firstly I am sometimes forced to open files as read only because they are 'locked for editing by another user' even when I am certain no one else is using them, because no one but me has access to them, I don't have another version of the file open. I also frequently have to open my personal workbook manually as this does not happen automatically, very frustrating but not the issues I am posting about.
When I open the Move or Copy dialogue box by right clicking on a sheet tab and click on the 'To book:' drop down I can see a workbook which isn't open as one of the options to move to, I think from memory that this always has the 'copy of' prefix. The workbook is not visible on my start bar, I have only one instance of excel running, task manager, Applications shows only one instance although there are two EXCEL.EXE processes listed in Task manager, currently one at 29.6mb and one at 6.9mb. if I try to move the sheet to it just for fun I get a 'Permission to this workbook is currently restricted' message.
This may not seem like a big deal but I am wondering if it is linked to the other two issues I have mentioned and I have experienced some unexplained crashes which have resulted in me losing work.
Thanks in advance for any help you are able to provide.
Luke
My second ever forum post, exciting times! I am using Excel 2010 in Windows 7 on a new work network and have a personal macro workbook. I mention these points because I have been having issues which are related to them. Firstly I am sometimes forced to open files as read only because they are 'locked for editing by another user' even when I am certain no one else is using them, because no one but me has access to them, I don't have another version of the file open. I also frequently have to open my personal workbook manually as this does not happen automatically, very frustrating but not the issues I am posting about.
When I open the Move or Copy dialogue box by right clicking on a sheet tab and click on the 'To book:' drop down I can see a workbook which isn't open as one of the options to move to, I think from memory that this always has the 'copy of' prefix. The workbook is not visible on my start bar, I have only one instance of excel running, task manager, Applications shows only one instance although there are two EXCEL.EXE processes listed in Task manager, currently one at 29.6mb and one at 6.9mb. if I try to move the sheet to it just for fun I get a 'Permission to this workbook is currently restricted' message.
This may not seem like a big deal but I am wondering if it is linked to the other two issues I have mentioned and I have experienced some unexplained crashes which have resulted in me losing work.
Thanks in advance for any help you are able to provide.
Luke
