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

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.




Reply
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
How do I allow users to make a choice in a worksheet? Jim Zavone Excel Worksheet Functions 2 June 23rd 05 12:09 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
Informatica Connect to Excel workbook Michael MacLachlan Excel Discussion (Misc queries) 0 December 3rd 04 11:15 AM


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

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

About Us

"It's about Microsoft Excel"