Trying to simulate 2 separate users in connection with a Share Wor

M

Matthew S

I’m using the Benchmark Series – Specialist & Expert for Excel 2003. I’m
working in Chapter Two (Expert Section) on the next to last Assessment (#7)
re: Sharing Workbooks.

This exercise calls for simulating two users, but I can’t get it done.

The instructions call for opening a file (eec2sc07) and (temporarily) naming
a fictitious user for and sharing the workbook.

I do this via Tools/Options/General > entering a fictitious User Name > and
clicking OK. Then, Tools/Shared Workbook and checking “Allow changes by more
than one user……â€, clicking OK and clicking OK again to save the workbook.

Next, to simulate a second fictitious user, the instructions tell me to open
a (supposed) separate version of Excel by clicking Start/All
Programs/Microsoft Office/ Microsoft Office Excel 2003. In this copy, I
change the user name to the second fictitious user – Tile Windows
Horizontally – click on the second user work book to select it and open the
file eec2sc07.

Supposedly the work book is now open in two separate copies of Excel with a
different user in each.

But, that’s not the result I get. I see the same user in both windows.
When I change the user name in one window/workbook, the user name in the
other changes as well.

I can only guess that I’m not opening two copies of Excel – even though the
instructions say that I should be.

I’m stuck. Any input will be greatly appreciated.
 
D

Dave Peterson

I get the same result as you. And I'd guess that's because this name is stored
in the windows registry. Each time excel looks to see the user name, it refers
to the registry.

But that's never stopped me from testing shared workbooks. I just use my name
in both instances of excel.

And if you can see that single workbook open in to windows of excel, you've
opened multiple instances.

I use
windows start button|run|excel
and hit enter
 
M

Matthew S

Thanks Dave. I'll give your approach a try.

Dave Peterson said:
I get the same result as you. And I'd guess that's because this name is stored
in the windows registry. Each time excel looks to see the user name, it refers
to the registry.

But that's never stopped me from testing shared workbooks. I just use my name
in both instances of excel.

And if you can see that single workbook open in to windows of excel, you've
opened multiple instances.

I use
windows start button|run|excel
and hit enter
Click to expand...
 
Top