Drop Formulas when refreshing data from external source

G

Guest

I pull data in Excel from an external source through an ODBC connection into
a SQL Server database. When I refresh the data, Formulas are dropped for
entire rows and then rows will pick up the formulas again, leaving gaps in
the middle the spreadsheet with missing formulas. I go back in and copy the
formulas back into the rows that are missing the formulas and it works fine.
 

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

Refreshing formulas automatically 3
Complicated ODBC data refresh question. 6
How to manage new data with external data in Excel? 1
Formulas not recognizing new data 1
Linking to Access data without destroying formulas 16
Combining Two Formulas to One 1
Excel 2007 from Excel 2003 #N/A Problem 1
Problems with Array Formula - 2 data criteria 2

Top