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...

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?

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...

I have created a pivot chart and then saved it as a Form. i then created a command button which is to open this form to view the pivot. So the user open the pivot when he click this button. Now the user can drag/drop some fields... like they drag out a row field. he exit. when he re-presses...

I am using this calendar so that the user can pick a date from this calendar to put in the text box. Is it possible i can disable past dates on this calendar so that user can pick dates >=Now() ? if yes, how? for example when you book vacations online, the internet website will not allow...

I have a column in the field which is the date the data is uploaded and is not sorted by this date. How do i display the latest date on a form in a text box? 1 Jan 2009 2 Mar 2008 2 May 2008 so on my form latest uploaded date should be 1 Jan 2009. how do i do that? do i have to query the...

I have followed this forum advice and i have split the database into FE and BE. Converted the FE into .mde Now i have emailed the FE/.mde to all users of my department so that they can do data entry. after distributing, i have modified a report/query. So i recreated the .mde and then i need...

Cell A2 value:- 3503470.54999995 but when formated it is 3503 T Cell A3 Value:- 2725770.01999996 but when formated it is 2726 T When i do "=A2-A3" in A4 it is 778 T it should be 777 T... How do i change the formula in A4 to show 777 T instead of 778 T... this is rounding...

I have a multi user database and I have split the database and then convert to MDE to distribute to my 10 users. sometime i have to add or delete records in the background. So the front end users are affected if they have the form open. If I delete, If one or more users has the form open...

Hi I have an access database which is shared with 10-15 users. On a daily basis, I update the access database with excel data which changes everyday and then update the access database. I use VBA macro in excel to do that by updating the table in access i.e open connection to access...