Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Location
    London, Gtr London
    Posts
    131
    Thanks
    0
    Thanked 0 Times in 0 Posts

    General Excel Question (2002)

    I recently used an excel spreadsheet that consisted of a number of sheets all of which seemed to link together with data and graphs etc. The thing about this was, that when I wanted to trace where and how the figures arrived onto the different sheets, I couldn't see any formulas. I went into the VB code and there wasn't any code either.

    How is it possible to make excel transfer/use data on one sheet and make it available on another sheet or graph etc. without showing the formulas/code?

    Is there any suggested reading anyone might recommend so that I can learn more about this?

  2. #2
    New Lounger
    Join Date
    Mar 2003
    Location
    Cardiff, Wales
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: General Excel Question (2002)

    It looks as if the worksheets might be protected, with the cell formulas being hidden.

    This is done by selecting the cells whose formulas you wish to hide, then going to Format / Cells and on the Protection tab clicking Hidden.
    You then need to select Protection from the Tools menu and choose Protect Sheet. Type a password if required and click OK

    In your case, You will be able to view the formulas by using Tools / Protection / Unprotect sheet ( this supposes that the sheet is not password protected)

    Dave <img src=/S/compute.gif border=0 alt=compute width=40 height=20>

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: General Excel Question (2002)

    Its not possible to transfer data to other areas without using some or other form of formula or code!
    The only other option that comes to me is that the person who set up the workbook has added a sheet password to the sheets and activated the Hide option when password protecting it.
    If you choose Format|Cells, and click the Protection tab, you can activate the Hidden option which hides all formulas from displaying in the formula bar!
    Regards,
    Rudi

Posting Permissions

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