Disabling formulas and turning file into text only
 

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?

Not 100% sure, but I think you can do this by going
edit/links/break links.


-----Original Message-----
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?
.

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

"Christine" wrote:

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?

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_...=100&hl=en&lr=

--or--

http://groups.google.co.uk/groups?as...um=100&hl=e n

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

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Nagar" wrote in message ...
hi.. u can copy the copy cells in do a paste sp. but only paste values only..
hope this help

"Christine" wrote:

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?