Recent content by boumbo

when i have one pivot on one sheet, the excel 2007 speed is ok even though the datasource is from another workbook. However, when i have two pivots [pivot A & pivot B]side by side on one sheet, the sheet becomes slow and the screen update slows down. when i scroll down for example, it takes...

Yes No so any solution? :)

i have these in a column. each line is a row 128982 VC AAAA 1389883; MC AAAA 1589 DC BBBB 179024;VC DDDDD 1212313;AM EEEEE 18902 MC FFFFF 18902 FFFFF 3033383; B#111; VC; XXXX 3035383; B#222; DC; YYYY i want the next column to be VC MC DC VC AM MC <blank> VC DC any formula i can put in...

windows scheduler:- macro I have configured windows schedule to open a workbook and in the open event of the workbook i have the following code:- Private Sub Workbook_Open() MsgBox "TESTING" End Sub The windows scheduler opens the excel and I can see the excel open in the taskbar. But the...

Is there a limit to link excel to other excels? I have 1 master excel and about 50 small excels. the master is linked to the 50 excels. each cell in the master is link to one cell in one of the small excel. I notice that when we a certain amount of linked data, link does not work anymore...

Is there any problem using UNC[\\shareddrive\] as opposed to letter drive[H:\test]. I have a big excel with a lot of rows which are linked to different closed workbook. sometimes with the UNC i find that that master is not updated even though the link is there.. is this common?

do you have any alternative to Dmax too? I am getting rid of all my D functions...as i find out that this slows down my database a lot.. there is a lot of improvement now that i got rid of dlookup. is there any alternative for dmax?

It works.. you are a genius!:)

when i switch it back to dlookup, it works fine.. so i dont think it is the table right?

yes i have microsoft dao 3.6 object library ticked in the reference box. :confused:

Yes. :) I have debuged it too.. It is going into the function but the error message is "syntax error in FROM clause" the SQL statement seems to be wrong. it goes to error when it reaches this line Set rs = db.OpenRecordset(strSql, dbOpenForwardOnly) when debugged The strSql is: "select...

ok.. i have included it in module 1 and then change this code to 'strFEMaster = DLookup("fe_version_number", "tbl-version_fe_master") strFEMaster = ELookup("fe_version_number", "tbl-version_fe_master") ' looks up the version of the front-end on the front-end 'strFE =...

how is the performance?? is it not another compound function? therefore it will slow down on shared network?

it works fine now.. but i need to solve the performance issues as it is slowing down the database. i read that dlookup is not recommended since it slows down on the network. are there any alternative to use other functions other than dlookup as per below:- ' looks up the version of the...

Try these headers in two columns. Doc.no. Inv Rec'd Date