Accessign formula's in worksheet that appear to have been hidden

T

Tim Ashcom

I have an Excel worksheet with columns and rows of data. In order to make
computations, as you know (LOL) a formula must be deveoped. This worksheet I
have did not come with any (or viewable formula's. Is there a way I can make
them re-appear?

Please let me know as soon as you can.

Thanks,
Tim
 
A

Anne Troy

Tim: Many spreadsheet "producers" will develop applications that wipe the
formulas because, quite frankly, they don't want you to know how they came
about getting the figures they got. Could this be the case?
*******************
~Anne Troy

www.OfficeArticles.com
 
T

Tim Ashcom

Anne,

Yes, this appears to be the case. Need to obtain these formulas somehow.
They appear to be some what common.

Thank you for your assistance.

Tim
 
A

Anne Troy

Perhaps I should have explained. If I have formulas I don't want you to see,
I'll copy the cells, and hit Edit-->Paste special, Values, OK.
Formulas...all gone!
*******************
~Anne Troy

www.OfficeArticles.com
 
T

Tim Ashcom

Anne Troy,

So no way to back door the process and get the formulas? Appears that I'm
out of luck and have to do it the hard way.....

Thanks,

Tim
 
D

Dave Peterson

Developers can lock the cell, hide the formula and protect the worksheet so that
formulas aren't visible.

Is the worksheet protected?

If no, then the formulas won't be hidden.
 
T

Tim Ashcom

Can I send you a file and your try your tricks? If so, how can I send you
the file?

Tim
 
T

Tim Ashcom

Anne,

I sent you the file to the following e-mail address: [email protected]

Is this your correct e-mail address?

Sent to you in .txt type file. Must rename too .zip before you attempt to
unzip. If you are successful, then shen you send back, send in .txt type
file.

Thanks again.

Tim
 
Top