How do I get a Project 2003 Gantt chart to refresh from the DB?

C

clicknclack

MSP_TASKS has been updated via an external SP. How do I get the Gantt chart
in the GUI to refresh without closing & re-opening the project?
 
R

Rob Schneider

clicknclack said:
MSP_TASKS has been updated via an external SP. How do I get the Gantt chart
in the GUI to refresh without closing & re-opening the project?
Click to expand...

What is "an external SP"?

In any event, turn on automatic recalculation, or press F9 key to
recalculate manually?
 
C

clicknclack

Sorry for the brevity. I have a stored procedure (SP) that simply inserts new
tasks into the MSP_TASKS table. All works fine (aside from some time-based
issues I still need to figure out), and, upon opening the specified project
in MS Project (Standard), the newly created tasks show up in the proper place
in the project's Gantt chart. However, I would like to be able to refresh the
Gantt chart to see tasks inserted after the initial load. Unfortunately,
pressing F9 doesn't seem to work. I've tried setting Calculation Mode to
Automatic and Manual, as well as the "Calculate Now" button on the Options
dialog's Calculation tab. Nothing seems to work except closing the project
completely and re-opening it. I'm sure I'm missing something obvious....
 
R

Rob Schneider

clicknclack said:
Sorry for the brevity. I have a stored procedure (SP) that simply inserts new
tasks into the MSP_TASKS table. All works fine (aside from some time-based
issues I still need to figure out), and, upon opening the specified project
in MS Project (Standard), the newly created tasks show up in the proper place
in the project's Gantt chart. However, I would like to be able to refresh the
Gantt chart to see tasks inserted after the initial load. Unfortunately,
pressing F9 doesn't seem to work. I've tried setting Calculation Mode to
Automatic and Manual, as well as the "Calculate Now" button on the Options
dialog's Calculation tab. Nothing seems to work except closing the project
completely and re-opening it. I'm sure I'm missing something obvious....
Click to expand...

Probably best to ask in the Project Developer's newsgroup. (I suspect
that since Project not really designed for this complexity you may be
barking up the wrong tree).
 

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

Create a chart from a table in word thats dynamic 0
How to display the merge function "url" of a picture? 0
Adding Baseline1 and Baseline2 on Gantt Chart View 0
Project 2003 Std. Refresh from DB 5
Narrower Gantt chart rows when printed 1
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
saving a gantt chart format/structure in MS Project 2007 7
Gantt Chart 'Overlay' from Project 3

Top