![]() |
excel/website interaction PLEASE HELP!!
Save the Excel spreadsheet as a web page and check the
activate formulae's box - that'll work. -----Original Message----- Hello all, I have a bit of a dilemma I'm trying to solve. Here it is: I have this excel spreadsheet that is a pretty advance cost return calculator kinda thing, the uses a whole bunch of complex calculations, links through multiple excel worksheets to provide that provides some analytical data (graphs and numbers) based on a whole bunch of inputs. What I need to do: I need some way to create a webpage where a user can enter all this input data, then have that page trigger the excel spreadsheet to perform the calculations, then return all the charts and data results back to the user either on the webpage or through e- mail. Does anyone have any ideas??? Thanks in advance, Greg . |
excel/website interaction PLEASE HELP!!
thanks for the reply,
but where is that "activate formula" box? when i try to save as webpage, all i see is the "add interactivity" box, but that doesn't work because my calculations span across multiple worksheets. thoughts? thanks in advance. -greg -----Original Message----- Save the Excel spreadsheet as a web page and check the activate formulae's box - that'll work. -----Original Message----- Hello all, I have a bit of a dilemma I'm trying to solve. Here it is: I have this excel spreadsheet that is a pretty advance cost return calculator kinda thing, the uses a whole bunch of complex calculations, links through multiple excel worksheets to provide that provides some analytical data (graphs and numbers) based on a whole bunch of inputs. What I need to do: I need some way to create a webpage where a user can enter all this input data, then have that page trigger the excel spreadsheet to perform the calculations, then return all the charts and data results back to the user either on the webpage or through e- mail. Does anyone have any ideas??? Thanks in advance, Greg . . |
All times are GMT +1. The time now is 11:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com