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
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,376
    Thanks
    35
    Thanked 393 Times in 340 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 - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

    *** 20% DISCOUNT ON PASTEL XPRESS / PARTNER SOFTWARE UNTIL 15 DECEMBER 2017 ***

    "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
    2,671
    Thanks
    88
    Thanked 544 Times in 460 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 and LED 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 adrianh's Avatar
    Join Date
    Mar 2010
    Location
    Cape Town
    Posts
    5,089
    Thanks
    336
    Thanked 808 Times in 642 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.
    How easily someone is offended is directly proportional to how stupid they are.
    ~GS Elevator

  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
  •