ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   find formula used when spreadsheet has been cut / pasted? (https://www.excelbanter.com/excel-discussion-misc-queries/140500-find-formula-used-when-spreadsheet-has-been-cut-pasted.html)

flossie lost it

find formula used when spreadsheet has been cut / pasted?
 
I have a spreadsheet which has been cut and pasted to hide formulas. I have
been told there is a way to reveal the formulas used, is there?

Bob Phillips

find formula used when spreadsheet has been cut / pasted?
 
If it is the values that have been pasted, then you can't get at the
original formula.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"flossie lost it" <flossie lost wrote in
message ...
I have a spreadsheet which has been cut and pasted to hide formulas. I
have
been told there is a way to reveal the formulas used, is there?




bj

find formula used when spreadsheet has been cut / pasted?
 
if it is copy and paste special values, you probably can't

you can try edit-goto-special-formulas

you can try tools-formula audting-trace dependants

"flossie lost it" wrote:

I have a spreadsheet which has been cut and pasted to hide formulas. I have
been told there is a way to reveal the formulas used, is there?



All times are GMT +1. The time now is 12:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com