Solved

Excel 2000 saving problem

Posted on 2001-06-11
2
135 Views
Last Modified: 2013-12-28
I have a problem in Excel to save some of the sheets. I link some of the sheets to Word and then it tells me that my sheet is locked by another user which is me ,when I try to save this work.
0
Comment
Question by:nitzke
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 1

Accepted Solution

by:
CJHarrap earned 50 total points
ID: 6176264
When you link Excel to Word, the Word process will open the excel sheet.  If you then try and save the sheet, Word is still running, so therefore Windows will report back that the file is open by another user... you.  What it should say is that is open by another process....  try and close Word first, or don't link when the file is open by you in Excel.

Cheers,
CJ.
 
0
 
LVL 7

Expert Comment

by:pbessman
ID: 6177055
CJ is right.  Linking stuff before you save it causes issues.  Once the item is linked you should close the other application and save it.
0

Featured Post

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An article on effective troubleshooting
Learn how to PXE Boot both BIOS & UEFI machines with DHCP Policies and Custom Vendor Classes
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question