Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cells not refreshing...
I am using EXCEL 2003 and I've got a workbook that has been working. Part of
the functionality is that it goes out to a SQL database and imports a subset of data onto a sheet in the workbook. There is a summary sheet that I'm using to organize the data subset. I'm using a couple of Domain Aggregate functions (DCount and DCountA) to sum the total rows of data and the total non-blanks rows of data. This is all working great. What I want to do now is - on a separate worksheet - capture the summaries by day so that I can display a trend chart on a rolling 30 day window. I've created 7 variables in my subroutine (one for date and 6 for the individual data values I want to trend) as Var1, Var2, Var3, etc and I'm setting these values equal to the cells in the summary sheet that it's normally found. My thoughts were that once I've set each of the variable to it's respective cell on the Summary sheet, I could just right those values onto the sheet that will store the data for the trend chart. What I'm find is that when I run the macro it puts the date in the correct spot and all other data fields are equal to zero. If you check the summary page there are non-zero values there. I accidentally discovered that if I put a break in the code, the Vars eventually get populated with the right values and subsequently the storage sheet gets the right values. It's almost like the subroutine gets done running before the cells get updated on the summary sheet. And FYI I'm doing this with 2 different sub-routines. The first routine populates the fields on the summary page and the last line of that sub calls the other sub which is supposed to populate the sheet for the trend chart. I'm missing something simple I suspect. Thanks Jeff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linked cells not refreshing | Excel Worksheet Functions | |||
refreshing cells? | Excel Discussion (Misc queries) | |||
refreshing formulas in cells | Excel Discussion (Misc queries) | |||
Why are the cells of my workbook not refreshing? | Excel Worksheet Functions | |||
refreshing formulas in cells | Excel Discussion (Misc queries) |