Have you checked that the file isn't actually read-only through Windows? In Win7 you can find it here: C:\Users\AppData\Roaming\Microsoft\Excel\XLSTART\Personal.xlsb (if you don't have a 'Roaming' folder, replace that with 'Local'). Right-click the file and check if the 'Read-only' tick-box is ticked. If it is, un-tick it.
If that's not the problem, are you trying to open a second instance of Excel? If so, the first instance will 'lock' Personal.xlsb so it is then read-only for the second.
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
Hi Aardigspook,
I did go to the file in the XLSTART folder and check it's attributes by right clicking on it - neither "read only" or "hidden" were ticked.... so that's why I was confused that when I tried to hide it using "View", "Hide" and then save the workbook that I got the message "This file is read only" ....
I wonder if I tick the box "Hidden" if that will then hide it .... or will it only do that if I then save it..... which will then take me back to the message "This file is read only" ....
If you have any further thoughts that would be helpful...
thanks, Neil
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks