Results 1 to 6 of 6

Thread: Excel info needed

  1. #1
    Gold Member
    Join Date
    Mar 2012
    Location
    Vanderbijlpark
    Posts
    886
    Thanks
    83
    Thanked 381 Times in 298 Posts

    Excel info needed

    Is it possible to determine the creation date of a worksheet within a workbook?

  2. #2
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    I'm not sure what you mean by "within a workbook", but I know that, if you right-click the Excel file (without opening it) and go to Properties, you will see the date on which the file was created, modified and last accessed.
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  3. #3
    Diamond Member Justloadit's Avatar
    Join Date
    Nov 2010
    Location
    Johannesburg
    Posts
    3,480
    Thanks
    134
    Thanked 695 Times in 593 Posts
    Blog Entries
    1
    In Excell usually under properties of the document under the 'Help" or "File" depending on the version will show the history of the file
    Victor - Knowledge is a blessing or a curse, your current circumstances make you decide!
    Solar pumping, Solar Geyser & Solar Security lighting solutions - www.microsolve.co.za

  4. #4
    Gold Member
    Join Date
    Mar 2012
    Location
    Vanderbijlpark
    Posts
    886
    Thanks
    83
    Thanked 381 Times in 298 Posts
    Hi Neville

    Thanks for the input.

    I have a workbook that consists of 3 worksheets.

    The workbook was created on 13/03/2014, and last edited on 27/05/2014

    I know that worksheet 1 was created on 13/03/2014, but I am trying to determine when worksheets 2 and 3 were created, as opposed to edited.

  5. #5
    Diamond Member
    Join Date
    Mar 2010
    Location
    Cape Town
    Posts
    6,329
    Thanks
    426
    Thanked 978 Times in 795 Posts
    I can't see that Excel would store that date. The worksheet is simply another object that lives in the workbook like a graph or a macro.

  6. #6
    Gold Member
    Join Date
    Mar 2012
    Location
    Vanderbijlpark
    Posts
    886
    Thanks
    83
    Thanked 381 Times in 298 Posts
    Thank you. I thought as much but I harboured a desperate hope!

Similar Threads

  1. [Question] Excel Help please
    By greghsa in forum Technology Forum
    Replies: 16
    Last Post: 04-Aug-14, 02:24 PM
  2. [Question] Online-Home-Jobs.com - Scam or not? (Article writing info needed also)
    By Darkangelyaya in forum Scam Alert Forum
    Replies: 3
    Last Post: 04-Mar-13, 05:12 PM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

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