Search results

thanks shades, will check it out.. right now i am re-creating the file, step by step, and changing pivot filter at every step to see when the time jump occurs. so far it looks like it's NOT the conditional formatting (although it did add a few seconds).. another peculiar annoyance in this...

hey, they just split, it's free for all now....

no idea! but i looked online, looks like there are a few tips here and there on how to 'en-lighten' the pivot tables. of course if you have suggestions i'd be more than happy to hear.. l

"moved to a new location" - dragging. just selected a block and dragged it on the same worksheet. thanks, for the cache tip (no pun), will try to kill that pivot table and redo it, see where it takes me. now, the data behind the pivot table (on the server) will be updated daily, so whoever...

another day another excel quirk! this is excel 2007, on xp. i made a few relatively innocuous changes - - added 1 variable to a pivot table (have 3 now) and rearranged them a bit, - eliminated about a 1000 rows of calculations, that used light formulas (double-nested IFs) and conditional...

worked like a charm! many thanks, Sam.. (just 'Sam' is good, i assume, since the whole handle asks for it?) it could be a new chapter in my relationship with excel.. (although we just had another argument, i am posting my complaint in a minute).. l

sorry for being mia - other projects etc. i'll get back to this very soon, will post progress.. thanks a bunch, Call_Me_Sam. l

duh, of course i am missing something! a complex output.. nevermind, TEXT it is.. something like TEXT(SUM(H55-D59),"$.00").. it's monday.. l

what if you just format the cell with your formula to whatever format you need? i feel like it should work just fine.. although sounds a bit trivial.. maybe i'm missing something.. let us know. l

great idea, thanks Call_Me_Sam! definitely will try that, although it will be a laborious exercise as i am not a good coder at all. couldn't understand your question, could you rephrase please?.. l

and extremely annoyingly.. whenever i trigger a change in a pivot table using the report filter, the heights of some of the rows involved in the action change without any logic. i have a bunch of cells to the right of the pivot table that change based on the pivot table modifications, and...

maybe it doesn't like the slashes? (i am assuming you are using mm/dd/yy, or similar.) see if it will work if you play with the date format, eg use mm-dd-yy, or even better custom mmddyyyy or similar. just an idea. l

FROM table1 INNER JOIN (SELECT Ratings.[Cust ID], First([Cust ID] & [Type]) AS CustType FROM Ratings GROUP BY Ratings.[Cust ID]) AS Qry1 ON table1.var1 = Qry1.var1 yes!!! it worked!... thanks much, MSAccessRookie (are you really?).. i was struggling with it for a few days now. feeling...

if i change "query1" to actual query syntax, it's not working.. e.g. FROM table1 INNER JOIN (SELECT Ratings.[Cust ID], First([Cust ID] & [Type]) AS CustType FROM Ratings GROUP BY Ratings.[Cust ID]) ON table1.var1 = (SELECT Ratings.[Cust ID], First([Cust ID] & [Type]) AS CustType FROM Ratings...

just a quick question - is it possible, in the statement below, instead of "query1" to put actual SQL syntax for that query? if not, is there a workaround? FROM table1 INNER JOIN query1 ON table1.var1 = query1.var1

also posted in Excel forum..

also posted in Excel forum.

hi. i have the strangest problem importing data into Excel from Access. in Excel, i go to Data, From Access, then i select the database of interest. it shows me all the tables and queries, i pick the one query i need, it opens the little dialog window where i select 'Pivot Table Report', and hit...

hi. i have the strangest problem importing data into Excel from Access. in Excel, i go to Data, From Access, then i select the database of interest. it shows me all the tables and queries, i pick the one query i need, it opens the little dialog window where i select 'Pivot Table Report', and...

thanks Pat. l