Sharing Worksheets

T

Tony

Earlier in the week, I got a question asked by one of my users about a
problem with a shared worksheet. The worksheet is an engineering time log
worksheet. When the user opens this worksheet on a co-worker's PC, it works
fine...by that I mean there are three drop down boxes that she can choose
things faster from as well as the panes are frozen both horizontally and
vertically.

When she opens the worksheet on her own PC, these drop down boxes don't
function and her panes are only frozen horizontally. Both workstations are
Windows 2000 and both Excel programs are Excel 2002 SP3. I just can't
figure out why this shared file will work on one machine and not the other.

Thanks for any help you can give.
--Tony
 
J

JP

Some settings are local, they are set by the individual user and don't
"follow" the workbook.

In other words, Shared doesn't mean Equal.

You can set some common options by going to Tools>Share Workbook and
going to the Advanced tab.


HTH,
JP
 

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

Top