Drop Formulas when refreshing data from external source

I

Indy-Joe

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
Query to Ex Data refresh changes formulas 0
Formula's won't read copy / pasted data ? 2
How to manage new data with external data in Excel? 1
Automatically populate formulas when a new row is inserted 0
copying formulas when inserting new rows 7
Linking to Access data without destroying formulas 16
Complicated ODBC data refresh question. 6

Top