Disabling formulas and turning file into text only

C

Christine

I have a workbook in which there are formulas that pull through from other
workbooks. I want to make the workbook so that it doesnt ask me to update the
formulas everytime and make it so that only the values show up(formulas are
no longer needed once computed) Is there a way to do that besides copying and
pasting as special?
 
N

Nagar

hi.. u can copy the copy cells in do a paste sp. but only paste values only..
hope this help
 
D

David McRitchie

Hi Christine,
Your question seems ambiguous to me, like is there another way to walk
without walking. Did you have something specific in mind.

I think perhaps you are asking if you can skip the using
the Selecta All (Ctrl+A), then Copy (Ctrl+C) then Edit, Paste Special, Values

You can record a macro, and then invoke that macro. or what it does
in another macro that goes through each of the sheets.
There have been postings on that. do a Google Groups search on:
convert entire workbook to values group:*excel*

http://groups.google.co.uk/advanced...ook+to+values+group:*Excel*&num=100&hl=en&lr=

--or--

http://groups.google.co.uk/groups?a...fe=images&as_ugroup=*Excel*&lr=&num=100&hl=en

If you want something to automatically determine when this macro is to run
to change to entire workbook to values then there has to be some manner
so that it is known when you are finished collecting data.

Getting Started with Macros
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Macro to cycle through sheets collection
http://www.mvps.org/dmcritchie/excel/sheets.htm
 
Top