Results 1 to 11 of 11
  1. #1


    Member Since
    Apr 16, 2013
    Posts
    36
    Tracking Changes
    Is it possible to go back and track the changes I have made to an Excel database say for the past week or two? I have a rather large database that I am constantly updating and I would now like to add those changes to a newer version of the same database. Or do I have to do a split screen and scan eack and every line to see any changes (some 19,000 lines)?

  2. #2

    lclev's Avatar
    Member Since
    Jul 24, 2013
    Location
    Ohio (USA)
    Posts
    2,762
    Specs:
    2011 MBPro, 2013 MBAir, 2010 MacPro, iPhone 6+
    If you have turned on "track changes", yes. Here is a link on how to do that.

    Turn change tracking on or off - mac excel

    If you have not turned tracking on previously I believe you are out of luck.

    Lisa

  3. #3


    Member Since
    Apr 16, 2013
    Posts
    36
    Tracking Changes
    I guess I should have mentioned that have Excel 2008 and when I just now found "Track Changes" it only offers to track my changes in color and I am supposing that it would only track the changes I make henseforth not changes I have already made, am I right?

  4. #4

    chscag's Avatar
    Member Since
    Jan 23, 2008
    Location
    Fort Worth, Texas
    Posts
    49,118
    Specs:
    Late 2013 27" iMac, iPad 3, iPhone 6s+, iPhone 6+, 3 iPods, El Capitan
    That's right. As Lisa pointed out, the "Track Changes" option would have had to be turned on previously. In other words, unless you turned it on when you first edited the sheet, those changes will not be shown. It's the same for Office 2008 Excel as well as 2011 Excel.

  5. #5


    Member Since
    Apr 16, 2013
    Posts
    36
    Tracking Changes
    Well, it looks like I've got some work ahead.

    While I have you here, the last time I used the split screen I could not remember how to sync the two so they move together, what is the command for this feature?

    Thank you both for the help!

  6. #6

    lclev's Avatar
    Member Since
    Jul 24, 2013
    Location
    Ohio (USA)
    Posts
    2,762
    Specs:
    2011 MBPro, 2013 MBAir, 2010 MacPro, iPhone 6+
    If I am understanding you correctly you want to split the screen and be able to scroll both at the same time in sync. In the 2011 version you click on the layout tab. On the right side of that ribbon is the Window section. In that section their are five buttons. You are looking for the button with the pop up that says: "Divide the current window into multiple resizable panes." Click that button and you should see a verticle and a horizontal gray bar appear on your spread sheet. You can grab the gray bars and it will allow you to resize the windows or move the bar off the spreadsheet if you don't want it. Once the bar is in place the scroll will sync automatically.

    I hope this is clear. If not let me know and I will try to clarify.

    Lisa

  7. #7


    Member Since
    Apr 16, 2013
    Posts
    36
    Lisa,
    I have 2008 Excel and I hit 'Windows' / 'Arrange' say 'horizontal' and I get my two databases in a split screen for mat. One is highlighted and that one scrolls, when I click on the other sheet, it is highlighted and scrolls but both are independent. There is/was a button to hit that would lock the two together and they would scroll at the same rate, so I can CK info from one to the other.

    I just tried it but cannot find the magic button to lock them. And "grab" does nothing at all!

  8. #8

    lclev's Avatar
    Member Since
    Jul 24, 2013
    Location
    Ohio (USA)
    Posts
    2,762
    Specs:
    2011 MBPro, 2013 MBAir, 2010 MacPro, iPhone 6+
    Ok, I admit to being unfamiliar with 2008 so I have found a link that might help. Scroll to the bottom of the article and it talks about spitting the screen. It seems the process is different in 2008 as compared to 2011.

    https://www.uwec.edu/help/excel07/ws-nav-m.htm

    Hope this helps.

    Lisa

  9. #9


    Member Since
    Apr 16, 2013
    Posts
    36
    Lisa,

    There is a difference between "Split Screen" and "Arrange" altho they do similar things. Split Chops the screen into smaller bites to give a close-up look at one section of a large file. While "Arrange" allows one to see two different files at the same time and compare one to the other. I have used "Arrange" many times to do this same procedure, but it has been (fortunately) several years since I did it last.

    I looked at the URL you added but it dealt with "Split" and did not help. But I do thank you for the effort.

  10. #10

    lclev's Avatar
    Member Since
    Jul 24, 2013
    Location
    Ohio (USA)
    Posts
    2,762
    Specs:
    2011 MBPro, 2013 MBAir, 2010 MacPro, iPhone 6+
    I guess I am not understanding what you need. Here is another suggestion for scrolling two different spreadsheets side by side in sync. Not quite sure it is the right version of office:

    View Two Excel Spreadsheets at Once | the MOST

    I also found Office for 2008 the missing manual on google books and it is searchable. Maybe this can help:

    Office 2008 for Macintosh: The Missing Manual: The Missing Manual - Jim Elferdink - Google Books

    Lisa

  11. #11


    Member Since
    Apr 16, 2013
    Posts
    36
    Lisa,

    I took a look at the book you showed me and I think that it would be a good buy for me. I didn't know that anything like this existed and I think it wii do the job.

    Thanks again for all your help and patience with me.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Tracking the OP
    By toMACsh in forum Community Suggestions and Feedback
    Replies: 6
    Last Post: 05-03-2010, 05:03 PM
  2. Tracking data use
    By davidcoad in forum iOS and Apps
    Replies: 6
    Last Post: 07-16-2008, 02:24 AM
  3. tracking device
    By pbjsandwich in forum Apple Notebooks
    Replies: 11
    Last Post: 07-01-2008, 08:43 AM
  4. tracking
    By sonoto999 in forum Schweb's Lounge
    Replies: 9
    Last Post: 01-30-2007, 03:37 PM
  5. Ip Tracking
    By menace3054 in forum Web Design and Hosting
    Replies: 5
    Last Post: 04-25-2005, 09:31 PM

Posting Permissions

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