Shared Excel file locked

Posted: 03-15-2007, 03:46 PM
I send Excel files via email to multiple users. The Excel files are [shared]
so that I can use the excel "track changes" function when I get the files
back from my users.

One of my users has just gotten a new computer with Vista, and she is unable
to save the file. Unfortunately, I don't have the specific message, but it is
something to the effect that the file is locked and she needs to remove the
[shared] function if she wants to save the file.

I suspect that the problem has something to do with Vista security settings,
but since she is 400 miles away from me, I don't have any way to do hands on
tech support with her computer.

Does anyone have any ideas on what the problem might be?

Help! Auntie
Reply With Quote

Responses to "Shared Excel file locked"

Jesper
Guest
Posts: n/a
 
RE: Shared Excel file locked
Posted: 03-15-2007, 05:31 PM
This has nothing to do with security in Vista. It is all related to the fact
that the workbook is shared and currently locked open.

See if this walkthrough helps:
http://office.microsoft.com/en-us/ex...035371033.aspx


"Auntie Annie" wrote:
> I send Excel files via email to multiple users. The Excel files are [shared]
> so that I can use the excel "track changes" function when I get the files
> back from my users.
>
> One of my users has just gotten a new computer with Vista, and she is unable
> to save the file. Unfortunately, I don't have the specific message, but it is
> something to the effect that the file is locked and she needs to remove the
> [shared] function if she wants to save the file.
>
> I suspect that the problem has something to do with Vista security settings,
> but since she is 400 miles away from me, I don't have any way to do hands on
> tech support with her computer.
>
> Does anyone have any ideas on what the problem might be?
>
> Help! Auntie
Reply With Quote
Auntie Annie
Guest
Posts: n/a
 
RE: Shared Excel file locked
Posted: 03-15-2007, 05:52 PM
Thanks for the reply, Jesper.

Unfortunately, there was nothing in the link that was helpful. What would
cause the shared file to be locked open? She is not on a network, so she is
the only one who is using the file at a time.

I have been using this particular process for 3 years with over 200
different users, and this is the first time I've come across this particular
problem. I even resent her the file in case there was a corruption in transit
issue.

Coincidentally, this is the first time I've worked with a user that I know
has Vista. (I have XP) She is using Excel 2000 and I am using Excel 2003.

"Jesper" wrote:
> This has nothing to do with security in Vista. It is all related to the fact
> that the workbook is shared and currently locked open.
>
> See if this walkthrough helps:
> http://office.microsoft.com/en-us/ex...035371033.aspx
>
>
> "Auntie Annie" wrote:
>
> > I send Excel files via email to multiple users. The Excel files are [shared]
> > so that I can use the excel "track changes" function when I get the files
> > back from my users.
> >
> > One of my users has just gotten a new computer with Vista, and she is unable
> > to save the file. Unfortunately, I don't have the specific message, but it is
> > something to the effect that the file is locked and she needs to remove the
> > [shared] function if she wants to save the file.
> >
> > I suspect that the problem has something to do with Vista security settings,
> > but since she is 400 miles away from me, I don't have any way to do hands on
> > tech support with her computer.
> >
> > Does anyone have any ideas on what the problem might be?
> >
> > Help! Auntie
Reply With Quote
Jesper
Guest
Posts: n/a
 
RE: Shared Excel file locked
Posted: 03-15-2007, 06:18 PM
> Coincidentally, this is the first time I've worked with a user that I know
> has Vista. (I have XP) She is using Excel 2000 and I am using Excel 2003.
Does the file say "shared" on your computer? I think you need to "unshare"
it. If you use the "Send to..." option in Excel it automatically shares the
file. Try opening the file on your computer and unshare it (should be under
the tools menu). Then save it and close Excel. Resend the file without
sending from inside Excel.

There are lots of troubleshooting docs on Office online about shared
workbooks. If you can nail down the specific problem one of them is bound to
help:
http://office.microsoft.com/en-us/ex...ared&av=ZXL110

BTW, I do not believe Excel 2000 is supported on Vista.
Reply With Quote
Auntie Annie
Guest
Posts: n/a
 
RE: Shared Excel file locked
Posted: 03-15-2007, 07:21 PM
No, I don't send files from within Excel. I do it the old fashioned way and
attach them to an email.

The file was shared on purpose and I don't want to use an unshared file
because it help me tremendously when I proofread the data that comes back to
me. I have nearly 20,000 records each year that I have to proofread, and I
need to use every tool at my disposal.

I'll keep on hunting for an answer. Thanks.

"Jesper" wrote:
> > Coincidentally, this is the first time I've worked with a user that I know
> > has Vista. (I have XP) She is using Excel 2000 and I am using Excel 2003.
>
> Does the file say "shared" on your computer? I think you need to "unshare"
> it. If you use the "Send to..." option in Excel it automatically shares the
> file. Try opening the file on your computer and unshare it (should be under
> the tools menu). Then save it and close Excel. Resend the file without
> sending from inside Excel.
>
> There are lots of troubleshooting docs on Office online about shared
> workbooks. If you can nail down the specific problem one of them is bound to
> help:
> http://office.microsoft.com/en-us/ex...ared&av=ZXL110
>
> BTW, I do not believe Excel 2000 is supported on Vista.
Reply With Quote
 
LinkBack Thread Tools Display Modes
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lost Part Of A File Excel 07 smileydb Windows Vista File Management 1 06-06-2007 09:44 PM
locked out of shared documents totally confused Windows XP Configuration & Management 2 12-11-2004 02:27 AM
File not loading when starting Excel bcummings Windows XP Configuration & Management 0 10-27-2004 05:23 AM
Unable to Open Shared Excel Files Mr Gonz Windows XP Help & Support 0 10-22-2003 09:47 PM
Excel file Jeff Windows XP Accessibility 2 07-07-2003 08:23 PM


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90