Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replacing Formula
Hi folks,
I need to develop a solution where an excel spreadsheet containig formulas has to be displayed on the web. The formulas should however be replaced by the calculated value. and the formula should not be visible in the displayed spreadsheet. Any tips or pointers in this regard would be appreciated Thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replacing Formula
James,
Copy all the cells, then do a pastespecial values, then save the workbook under a different name prior to publishing on the web. HTH, Bernie MS Excel MVP "James" wrote in message ... Hi folks, I need to develop a solution where an excel spreadsheet containig formulas has to be displayed on the web. The formulas should however be replaced by the calculated value. and the formula should not be visible in the displayed spreadsheet. Any tips or pointers in this regard would be appreciated Thanks in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replacing Formula
Hi Bernie
Thanks a lot for the pointer. "Bernie Deitrick" <deitbe @ consumer dot org wrote in message ... James, Copy all the cells, then do a pastespecial values, then save the workbook under a different name prior to publishing on the web. HTH, Bernie MS Excel MVP "James" wrote in message ... Hi folks, I need to develop a solution where an excel spreadsheet containig formulas has to be displayed on the web. The formulas should however be replaced by the calculated value. and the formula should not be visible in the displayed spreadsheet. Any tips or pointers in this regard would be appreciated Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help on replacing this formula | Excel Discussion (Misc queries) | |||
Replacing half a formula | Excel Discussion (Misc queries) | |||
Replacing formula | Excel Programming | |||
replacing value by formula | Excel Programming | |||
Replacing a value from a formula | Excel Programming |