Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Tim Ashcom
 
Posts: n/a
Default 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
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

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



  #3   Report Post  
Tim Ashcom
 
Posts: n/a
Default

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




  #4   Report Post  
Anne Troy
 
Posts: n/a
Default

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






  #5   Report Post  
Tim Ashcom
 
Posts: n/a
Default

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








  #6   Report Post  
Anne Troy
 
Posts: n/a
Default

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








  #7   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
  #8   Report Post  
Tim Ashcom
 
Posts: n/a
Default

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









  #9   Report Post  
Anne Troy
 
Posts: n/a
Default

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











  #10   Report Post  
Tim Ashcom
 
Posts: n/a
Default

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












Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Search/Match between 2 x separate Worksheets and populate result in third worksheet Alan Bartley Excel Discussion (Misc queries) 1 April 11th 05 05:21 AM
Copy worksheets with formulas between different workbooks Tim Excel Discussion (Misc queries) 3 March 31st 05 12:40 PM
Copy from worksheet to another x times Union70 Excel Discussion (Misc queries) 0 March 7th 05 09:03 PM
Dynamic Formulas with Dynamic Ranges Ralph Howarth Excel Worksheet Functions 5 January 21st 05 08:44 AM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM


All times are GMT +1. The time now is 05:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"