Excel File LOCKED

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Walrus2!!

Thread Starter
Joined
Oct 15, 2003
Messages
28
:confused:

Hello,
I have a multi part question about Excel. At work (a small family company) we have a spreadsheet that is used as an inventory and a customer history file. It has many pages probably between 10-14. The first and foremost problem is that it is LOCKED when opened and I can’t save changes or even save it under a new name. It is a shared file and we use it on our network of five computers. When it is opened it say’s LOCKED - to save changes; reopen before making changes-rename when saving; or turn off sharing. None of these things work. Also with this same file I had copied and paste from another file that was from a new supplier into it. My original file size was about 24mb after I cut and pasted from the other file that was 18mb I ended up with a final file size of 140mb! So ever since it would take forever to open and to save etc. Please HELP
 
Joined
Aug 30, 2003
Messages
2,702
(Ignoring the size for now,) sounds like it's corrupted. I believe XL2K2 has a good repair facility -- can you try it on a (non-network) machine that has 2K2?

Can you moved individual sheets out to a new workbook?

Rgds,
Andy
 

Walrus2!!

Thread Starter
Joined
Oct 15, 2003
Messages
28
XL Guru,

Your the man!! I had to copy all the sheets at once inorder to keep all the links proper but I'm back in buissness! Excel kept -not responding- during the copying but I kept "swiching" to it. Also my file size is now only 18.8mb which speeds things up greatly. Any Idea on how the file size grows like I explained?

Thanks you, XL Guru!! :)
 
Joined
Aug 30, 2003
Messages
2,702
A file can develop a lot of dead space as you work on it ; but that shouldn't have been affected by using the fix you did. If I said it might've been something to do with the corruption I'd be totally guessing.

Rgds,
Andy
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top