I cannot create a link bw two cells of two different excel workboks. I am using the correc
I cannot create a link bw two cells of two different excel workbooks. I am using the correct format (tried it on other machines). also, When I open the excel sheet, a dialog box appears "the file has been locked for editing by lenovo" (that's my machine name). It is weird because i do not remember changing any settings.
Please help.
excel version 2007
Hi and welcome to the forum
Try and create the link again
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I have.
Infact, around 10 people in my office have. Still no luck.
It is something to do with the locked for editing dialog box that appears.
Have you tried shutting down excel and then re-opening? or even a complete cold boot of your PC?
shared files?
Right-click-> My Computer->Manage->Shared Folders->disconnect the open file.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Tried a boot of teh system.
Unistalled>>reboot>>installed. Still does not work.
I even tries ur suggestion regardin the shared files. Still no luck.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks