Search results for query: *

Thanks for the help guys. I eventually found the glitch. The pivot table was linked to the database via the "data/import extrenal data/import data" menu in Excel XP. This gives the option to use a direct SQL link instead of ODBC, which is what I did. When I manually changed the filter...

SkipVought, I forgot to explain that MonthlyStFlow has linked cells which pull values from certain cells in the pivottable. These linked cells are what I'm copying and pasting into another section of the sheet with the operation : xlAdd to build up a cummulative figure. The delay in the pivot...

'Calculate Units For Each StkRef & Paste/Add To Existing Sheet x = 25 ' First Row Number Of Pivot StockrefList Do 'loop thru' this until end of list CurrentCellNumber = "A" & Format(x) CurrentCellValue =...

I know that its not refreshing the datsource but the actual pivot takes a couple of seconds to rebuild once a value is chosen in the filter. Before it has done this refresh the macro has already moved onto the next value and pluged that into the filter.

I've got a two sheet workbook. Sheet 1 has a PivotTable linked to a database. Sheet 2 is blank. I programatically move through the pivottable drop-down filter which cause the pivottable to recalculate. I then copy and paste those values to sheet 1. I then move onto the next value in the pivot...

Hi , I've got a database of staff clock-in / clock out times. What I want to do is report on the number of staff in work each hour of the day. If a person is in more than 35 minutes out of the hour then they are regarded as being in for that whole hour. Database example; Fields...