Results 1 to 8 of 8
  1. #1
    4 Star Lounger pauliez's Avatar
    Join Date
    Dec 2003
    Location
    Connecticut, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel 2000 Help (Two windows Help)

    I have two different excel 2000 workbooks on my PC screen sitting side by side.

    I use Windows>Arrange Windows>Vertical to view the workbooks side by side.

    What I am having trouble with is when I make a temporary change on the workbook on the left and then add some new info to the workbook on the right and hit the back arrow to bring the workbook on the left back to its original state, the change occurs on the workbook on the right.

    Is there a way to keep the workbooks very independent of each other?
    Catz

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel 2000 Help (Two windows Help)

    I think the only way to do that would be to open each workbook in a separate instance of Excel.

    Disadvantages:
    - Having two instances of Excel open consumes more resources than having two workbooks open in a single instance of Excel.
    - If you copy cells in one workbook and paste them into the other one, Excel will treat them as if they're from another application.
    - You have to right-click the Windows taskbar to arrange the windows.

  3. #3
    4 Star Lounger pauliez's Avatar
    Join Date
    Dec 2003
    Location
    Connecticut, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2000 Help (Two windows Help)

    Thanks Hans.

    I tried opening each workbook separately and used the task bar at the bottom of my screen to jump back and forth between the two workbooks, instead of having them aside by side, but the same thing happens.

    The only thing that seems to work for me is to write down with those prehistoric tools called a pad and pencil, close out the first workbook and then open the second workbook and add the info. <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>
    Catz

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel 2000 Help (Two windows Help)

    You'd have to do it like this:
    - Minimize all applications.
    - Start Excel.
    - Open the first workbook in this instance of Excel.
    - Start a second instance of Excel by (double) clicking a shortcut to Excel again.
    - Open the other workbook in the second instance of Excel.
    - Right-click the Windows taskbar and select the option to tile the windows vertically.

  5. #5
    4 Star Lounger pauliez's Avatar
    Join Date
    Dec 2003
    Location
    Connecticut, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2000 Help (Two windows Help)

    Thanks Hans.

    I will try your info tomorrow. It is almost midnight here and my eye balls are starting to hurt looking at the screen.

    Will get back to you with my results. Gotta beat this Excel!
    Catz

  6. #6
    4 Star Lounger pauliez's Avatar
    Join Date
    Dec 2003
    Location
    Connecticut, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2000 Help (Two windows Help)

    Thanks Hans

    Couldn't sleep thinking about this Excel problem. Got up and tried your info. IT WORKED! <img src=/S/joy.gif border=0 alt=joy width=23 height=23>

    Will put that one in my Fix-it box.

    One more thing. Is there a site where I can get just about every Excel formular that exist?

    Would like to play around with them a bit.
    Catz

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel 2000 Help (Two windows Help)

    See Function Reference. It's for Excel 2003, but with a very small number of exceptions it applies to Excel 2000 too.

  8. #8
    4 Star Lounger pauliez's Avatar
    Join Date
    Dec 2003
    Location
    Connecticut, USA
    Posts
    493
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2000 Help (Two windows Help)

    Thanks again Hans.
    Catz

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •