Refreshing Data from a web query

S

smith_gw

I import data from a third party application into Excel to run timeliness
reports. The application has functionality built in but not to the extent it
is needed. I have added columns in the spreadsheet that contain formulas to
determine the number of days between dates included on the report. When I
refresh the data, the data in the cells disappears. Is there any way to keep
these formulas or do I need to use this tab as a source document and build
the formulas in another tab or spreadsheet? Any assistance would be
appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Format change in merge data - Bold formatting after a comma 0
Refreshing formulas automatically 3
Creating a Search using a combo box and then creating a report. 4
Refreshing Pivot Table on a protected spreadsheet tab 1
Filtering data from a non-continuous list 3
Formula's won't read copy / pasted data ? 2
Drop Formulas when refreshing data from external source 1

Top