Search results

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

I tried the transfer command for import. but it has its limitation... for example there are some excel headers it does not like. like a two word headers(there is one space in between) any way to get around it. if i change header, yes it is super fast but the headers are the ones i get when...

i think it is doing this 2000 times thats why it is slow:- for loop insert table values 1, value 2 , value3, value4 into (_ .cells(rownumber, col 1), .LEFT(cells(rownumber, col 1),2), .MID(cells(rownumbercol2) ,1,2)) .MID(cells(rownumbercol3) ,1,2)) .MID(cells(rownumbercol4) ,1,2)) etc... )...

Thanks. I did it in access. but i find it very slow compared if i do it in excel. I have an excel sheet of 2000 rows. so i need to upload this into access. but in access the loop of row is very slow. when i run my macro in excel to upload in access, the upload is fast compared if i loop...

i have data in excel which i need to put into access. The data needs to be "massaged" before i upload it into access. I currently have a macro in excel to do it. this macro opens the table in access through DAO. then it loops into the excel sheet row by row while taking bits and pieces of...

he has excel and word installed but no access. should it make a difference? he can open my form and update database. but when i click shift + enter on the MDb... nothing happens. it cant go in the design mode. what is runtime? how do i check if he has runtime?