Re: Show value, not formula in formula bar

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Derochema (anonymous_at_discussions.microsoft.com)
Date: 06/24/04 

Date: Thu, 24 Jun 2004 10:41:50 -0700

No it would'nt work because this is a report created
daily. No one would be able to go in do that for each
report. What happens is some value come into the excel
from sql server, the report then has some formulas that
grabs totals etc...

Thanks for your reply.
Mike

>-----Original Message-----
>How about selecting the entire *** and convert all
formulas to values ?
>If this is palatable, .. :
>
>Press Ctrl+A to select entire ***, then
>Right-click > Copy
>Right-click > Paste special > Values > OK
>
>--
>Rgds
>Max
>xl 97
>---
>Please respond in thread
>xdemechanik <at>yahoo<dot>com
>----
>"Derochema" <anonymous@discussions.microsoft.com> wrote
in message
>news:2096601c45a02$2ba0cf10$a601280a@phx.gbl...
>> We have a client that does not want to see the formula
in
>> the formula bar. I decided to protect the excel report
and
>> hide all formulas, but that is not good enough. They
still
>> want to be able to see the value in the formula bar.
>> Anyone have any idea how this can be done?
>
>
>.
>

Quantcast