when i import some data from web the formulas used in that data in web page donot appear in the excel sheet. i want to import the data along with formulas used in that data.can you help me?
I am not sure I understood your question. Your web data has formulas in it? How are they mentioned? Are they like =A1+B1 or someother way? I am not sure if excel can import and process these formulas effectively.
But there is a work around if you just want to dynamically build formulas from imported data. Just write formulas in adjacent columns. And Set the option to extend formulas from web query settings (right click on imported data, select options or something).