Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing formulas to their result values
I'm working with a large multi-tab file that I have full of functions to
auto-fill and auto-calculate database values, to save me time on having to fill all that stuff out by hand. But the recipients of that file get all sorts of sorting glitches when they try to upload that file into their database(it uploads the formula instead of the values) Is there a way to convert all formulas in a file into their result values so that when I send the file to the uploaders there are no formulas in their copy? Hiding the formulas doesn't work--the sent file has to be void of formulas altogether. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing formulas to their result values
hi
do a file save as first so that the save as file will be the file you send. before you send, copy the sheet and paste special - values. this will convert all formula to values. Regards FSt1 "eejitrecords" wrote: I'm working with a large multi-tab file that I have full of functions to auto-fill and auto-calculate database values, to save me time on having to fill all that stuff out by hand. But the recipients of that file get all sorts of sorting glitches when they try to upload that file into their database(it uploads the formula instead of the values) Is there a way to convert all formulas in a file into their result values so that when I send the file to the uploaders there are no formulas in their copy? Hiding the formulas doesn't work--the sent file has to be void of formulas altogether. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Stop Date Values from Changing to Formulas | Excel Worksheet Functions | |||
Changing Default Search in to Values Not Formulas in Excel | Excel Discussion (Misc queries) | |||
Changing values but not formulas | Excel Worksheet Functions | |||
changing formulas to values so that they will be recognized by Find and Replace | Excel Discussion (Misc queries) | |||
Changing a formulas result to be a static number | Excel Discussion (Misc queries) |