Saving book without formulas

  • Thread starter Thread starter jcarlosd32
  • Start date Start date
J

jcarlosd32

I have a report with lots of formulas but I would like to save a
different version of the file containing only the current values, not
the formulas, so the new version of the report will show just the
values and there will be no possibility to see the formulas used in the
original book.

Is there any autamatic option to save the excel file this way ? I know
I can select all and say copy and paste values but I would like to
avoid that option.

Thanks !!

J.Carlos
 
Hi J,
Why not record a macro with the Copy|Paste Values method?
Or have you tried saving the file as a comma delimited file? This will keep
values not formulas and will open in Excel. - only one worksheet per
workbook
Bernard
 
Hello Bernard,

I think you are right, the best way to do it is creating a simple macro
that selects all and copy values. I was trying to avoid the use of
macros for this concrete report but I think there is no option.
Saving the file in other format (txt and others) will not save the
formulas, but I will lose all the output (colors, etc).

Thanks for your answer,

Later,

J.Carlos
 
Back
Top