• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

IMPORTING DATA IN EXCEL FROM WEB WITH FORMULAS

qammer

New Member
Hi!

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?
 
Hi,


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).
 
Back
Top