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

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

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


"Tim Ashcom" wrote in message
...
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

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



"Anne Troy" wrote:

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


"Tim Ashcom" wrote in message
...
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

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


"Tim Ashcom" wrote in message
...
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



"Anne Troy" wrote:

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


"Tim Ashcom" wrote in message
...
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

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

"Anne Troy" wrote:

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


"Tim Ashcom" wrote in message
...
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



"Anne Troy" wrote:

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


"Tim Ashcom" wrote in message
...
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

Not unless the formulas are hidden somehow, but I doubt it. I'd only be able
to tell if I could see the workbook. Sorry.
*******************
~Anne Troy

www.OfficeArticles.com


"Tim Ashcom" wrote in message
...
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

"Anne Troy" wrote:

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


"Tim Ashcom" wrote in message
...
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



"Anne Troy" wrote:

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


"Tim Ashcom" wrote in message
...
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

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.


Tim Ashcom wrote:

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

--

Dave Peterson

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

Tim

"Anne Troy" wrote:

Not unless the formulas are hidden somehow, but I doubt it. I'd only be able
to tell if I could see the workbook. Sorry.
*******************
~Anne Troy

www.OfficeArticles.com


"Tim Ashcom" wrote in message
...
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

"Anne Troy" wrote:

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


"Tim Ashcom" wrote in message
...
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



"Anne Troy" wrote:

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


"Tim Ashcom" wrote in message
...
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

Sure, Tim. Send to Anne@
The website in my signature.
*******************
~Anne Troy

www.OfficeArticles.com


"Tim Ashcom" wrote in message
...
Can I send you a file and your try your tricks? If so, how can I send you
the file?

Tim

"Anne Troy" wrote:

Not unless the formulas are hidden somehow, but I doubt it. I'd only be
able
to tell if I could see the workbook. Sorry.
*******************
~Anne Troy

www.OfficeArticles.com


"Tim Ashcom" wrote in message
...
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

"Anne Troy" wrote:

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


"Tim Ashcom" wrote in message
...
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



"Anne Troy" wrote:

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


"Tim Ashcom" wrote in
message
...
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

Anne,

I sent you the file to the following e-mail address:

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

"Anne Troy" wrote:

Sure, Tim. Send to Anne@
The website in my signature.
*******************
~Anne Troy

www.OfficeArticles.com


"Tim Ashcom" wrote in message
...
Can I send you a file and your try your tricks? If so, how can I send you
the file?

Tim

"Anne Troy" wrote:

Not unless the formulas are hidden somehow, but I doubt it. I'd only be
able
to tell if I could see the workbook. Sorry.
*******************
~Anne Troy

www.OfficeArticles.com


"Tim Ashcom" wrote in message
...
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

"Anne Troy" wrote:

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


"Tim Ashcom" wrote in message
...
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



"Anne Troy" wrote:

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


"Tim Ashcom" wrote in
message
...
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