View Single Post
  #4   Report Post  
Matthew S
 
Posts: n/a
Default

Thanks Mike.

"Mike" wrote:

older excel versions would open up separately

"Matthew S" wrote:

Im using the Benchmark Series €“ Specialist & Expert for Excel 2003. Im
working in Chapter Two (Expert Section) on the next to last Assessment (#7)
Sharing Workbooks.

This exercise calls for simulating two users, but I cant 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, thats 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 Im not opening two copies of Excel €“ even though the
instructions say that I should be.

Im stuck. Any input will be greatly appreciated.