+ Reply to Thread
Results 1 to 2 of 2

Need to replicate formulas not visible a locked spreadsheet - Excel 2007

  1. #1
    Registered User
    Join Date
    02-22-2013
    Location
    Workington
    MS-Off Ver
    Excel 2010
    Posts
    35

    Need to replicate formulas not visible a locked spreadsheet - Excel 2007

    Hi, I would be very grateful if anyone can provide advice as to the formulas used in the attached sheet and how I may be able to replicate them.

    I would like to create a similar sheet for my own event which will be held using multiple heats (ie i will require columns 1-10 as opposed to 1-6), and with different race names etc.

    Many thanks in advance.

    Steve
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,619

    Re: Need to replicate formulas not visible a locked spreadsheet - Excel 2007

    Without the worksheet password, you cannot unprotect the worksheet and, unless you unprotect the worksheet, you cannot see or copy the formulae.

    Unfortunately, we cannot assist you in circumventing security mechanisms.


    Potentially, your post does not comply with Rule 11 of our Forum RULES.

    Don't post questions regarding breaking or bypassing any security measure. Such posts will be deleted, and repeat offenders will be banned. This includes posting of links to sites that offer software, code or services to do this or posting of code to remove passwords

    Thread Closed
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 09-23-2014, 03:40 PM
  2. Replies: 0
    Last Post: 08-01-2013, 12:18 PM
  3. CAGR Linear Graph in Excel 2007 - How do I replicate the sample I have?
    By bridgetg in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 08-24-2012, 10:10 PM
  4. Cells getting locked while running macro in Excel 2007
    By asapu_mahe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2010, 12:46 AM
  5. Put comments on a locked spreadsheet even though cells not locked
    By RDP in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-11-2005, 07:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1