Excel info needed

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • CLIVE-TRIANGLE
    Gold Member

    • Mar 2012
    • 886

    #1

    Excel info needed

    Is it possible to determine the creation date of a worksheet within a workbook?
  • Neville Bailey
    Diamond Member

    • Nov 2010
    • 2786

    #2
    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)

    Comment

    • Justloadit
      Diamond Member

      • Nov 2010
      • 3518

      #3
      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

      Comment

      • CLIVE-TRIANGLE
        Gold Member

        • Mar 2012
        • 886

        #4
        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.

        Comment

        • adrianh
          Diamond Member

          • Mar 2010
          • 6328

          #5
          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.

          Comment

          • CLIVE-TRIANGLE
            Gold Member

            • Mar 2012
            • 886

            #6
            Thank you. I thought as much but I harboured a desperate hope!

            Comment

            Working...