Updating fields in excel

The user will then select a Text value in a Drop Down List and the corresponding key value will be inserted into the database table.

Therefore, when Word tried to update the fields, it went looking for something that didn’t exist and got itself into an infinite loop of looking and looking.

Once I’d taken a screen capture of that chart (with the author’s permission) and inserted that into the document instead, the fields updated in just a few minutes, as they normally do for these client documents.

See the section Selecting which cells that should be exported above for more details.

If you need to manipulate the data that has been updated in SQL Server, you can create a Post-Save SQL Query in SQL Spreads that will be executed after the Excel data has been updated in the SQL Server tables.

However, creating complex charts in Excel can be intimidating, so it’s easy to end up settling for simple charts which require a lot of work to maintain.

Charts help shorten the decision-making process, as we can immediately see our results and where we need to make changes.

The user will have the option to Overwrite or keep the conflicting changes.

Export all rows below selection that contains data If selected, SQL Spreads will grab all the rows with data below the selection and export them to the SQL Server table.

When I tried to update the fields in Word 2010, I immediately got a message that a link couldn’t be found. This was an *excellent* error message — it told me the type of object that it couldn’t find (‘Chart’) and it told me where to go to see the links. (although it would be an even better message if there was a button to take you straight to that location…) I went to that location (File Edit Links to Files).

Scrolling through the list of links in the Links window showed one that wasn’t like all the rest.

You won’t have to depend on others to manipulate or mess up the chart, and you won’t have to do all that extra work either.

Tags: , ,