Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
toxicmelon
Starting Member
2 Posts |
 Posted - 2004-07-05 : 09:23:18
|
| I have setup a simple DTS package that exports data from SQL to Excel which all works fine. This runs every night creating a new spreadsheet each time from a template.The problem is that I have other excel sheets that contain formulas that link to this data. If I open one of the linked sheets without manually opening and saving the spreadsheet that contains the exported data then excel gives the error that the data in this sheet has not been recalculated and I have to open the spreadhseet and save.If however I open and close the spreadsheet containing the exported data first the other spreadsheets are fine.I do not really want to keep opening and closing the export spreadsheet every morning - has anyone come accross this before or have a solution? |
|
|
toxicmelon
Starting Member
2 Posts |
Posted - 2004-07-08 : 12:32:50
|
| Sorted.I had a formula on the DTS destination Excel sheet that was not recalculated without opening and closing the spreadsheet. I have since removed this calculation and it works fine! |
 |
|
|
|
|
|
DTS Export To Excel Calculation Problem