Excel 2002: Shared Workbook won't Unshare

K

Kimberly

My supervisor locked virtually everything in a spreadsheet
that he planned to share on network. Nearly everyone but
me could access (I have 97). Meanwhile, IT suggested that
for the time being he remove password, which he did, but I
still can't access (a side problem ... not my question).

The problem:
file shows as shared but won't let him unshare. I am not
savvy with VBA (I helped him create his spreadsheet), so
there are no behind-the-scenes programming. Also, an
unknow password kept popping up in a grayed out box under
Tools --> Option --> Transition --> Save .... We did
something (I don't remember what) and it went away ... at
least for the time being.

We finally saved file to new name ... no go... still
couldn't unshare.

Bottomline: Does anyone have suggestions to regain the
ability to unshare? He can't make changes to any sheet
w/out it.

Thanks for whatever help you can offer.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unshare a Shared Workbook 1
Windows Defender Won't Install 4
Excel can't open some spreadsheets sometimes (so very very odd) 1
Shared drive won't let Access XP open a file. 1
Shared workbook opened in Excel 2002 on a Wk2 server with terminal services & opened Excel 97 on a N 0
cant open excel & word docs that have ben emailed etc 2
Why won't Outlook 2007 retrieve my email??? 8
Windows won't boot, stuck on mup.sys, other problems 0

Top