LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Matthew S
 
Posts: n/a
Default Trying to simulate 2 separate users in connection with a Share Wor

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.




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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
Separate first and second name in one cell into separate cells. Dwight in Georgia Excel Discussion (Misc queries) 3 January 25th 06 09:09 PM
Trying to simulate 2 separate users in connection with a Share Wor Mike Excel Discussion (Misc queries) 0 August 29th 05 09:56 PM
How do I save an OLAP connection to distribute with an Excel sheet JohnA Excel Discussion (Misc queries) 0 May 19th 05 03:35 PM
Separate first and second name in one cell into separate cells. Gary's Student Excel Discussion (Misc queries) 0 April 27th 05 11:11 PM
Protecting Workbook Paul Cooling Excel Discussion (Misc queries) 2 March 7th 05 11:55 AM


All times are GMT +1. The time now is 10:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"