Search results

Hmm.. Tried it again and it has worked. FOr some reason it was not saving the conditional formatting as a pivot change !!!

Hi, I have various pivot tables that a user can interact with. I would like to show data bars the start of a refresh of the pivot table and also when the pivot table is changed. At present I am selecting conditional formatting - data basrs yet when I change the pivot table the data bar...

1. How is the data stored as I would look at an additonal field which converts the date format to mmm-yy giving you the field month-year. When you then look at the data from a pivot table the item field month-year will group the data for you. I have this type of data stored in an Access Db...

I have found the answer.. it is the simplest of all. set the date cells not as custom mmm-yy Set as text and then input the dates manually. Then the formula works. NO more manually formulas just simple copy and paste. many thanks.

=IFERROR(GETPIVOTDATA("Incident ID+",'PSO R&C Table'!$A$3,"Group*+","User Security","Resolved Month / Year","Oct-13"),"0") I would like to change this from Oct-13 to the cell reference on the data sheet. e.g. =IFERROR(GETPIVOTDATA("Incident ID+",'PSO R&C Table'!$A$3,"Group*+","User...

Hi, My pivot table show Count of Incident_ID by Month and Year. I have the ID with duplicates which I gain from an Access DB. 1 Connection gives me the grand total of 23000 as an example. I would like to have a second pivot tables showing with duplicates removed. 2nd Connection would...

Thanks for the advise. have found a program that will sync pivot table fields. So that is my option.

can I join Date Month / Year from each splicer if they are from different databases and show in different connections and are on different pivot tables ?

Hi, Just becoming familiar with splicers. I can link together my pivot tables with splicers via a connections. My question is this. If I have connection1 = Access DB Data Set 1 Connection2 = Access DB Data Set 2 If the fields are the same name can I link these together if they are on...

Thansk Colin. Will follow the advise and test from there. Long day testing tomorrow... many thanks for the other input by the members here. Will keep you posted.. thanks.

It never makes it to the module as the updates take too long. I think simple solutino would be to which of refresh on all pivot tables and place refresh in all vba programs required ? Is this the best idea..... ? Also is it best from experience to go from .xls to .xlsm ? Thanks.

And Module all the top lines are the same oExcel.Run "AddToCellMenu" Here are examples of modules : Sub PivotAndDropDownUpdateNow() Application.Run "DropDownUpdateNow" 'this updates all dropdown boxes Application.Run "PivotUpdateNow" 'this updates all pivto tables Sheets("Dashboard...

option explicit Dim oExcel, oStats Set oExcel = CreateObject("Excel.Application") oExcel.Visible = True oExcel.DisplayAlerts = False oExcel.AskToUpdateLinks = False Set oStats = oExcel.Workbooks.Open("H:ReportsStatistics DataPSO Dashboard.xls") oExcel.Run "PivotAndDropDownUpdateNow"

Hi JB. the module are very large. they do various configurations to the dashboard. 1. the dashboard uploads the data. 2. i think the module times out as the dat takes about 1-2 mins to upload into teh pivots. I can give a sample of the dashboard. I think module calling in vbscript can...

Its Now. Windows 7 and Office 2010. I was move onto it last week. have changed alot of my work. yet this is the biggest challenge.

With .xls error : The server threw an exception code : 80010105 oExcel.Run "ModuleMenuRun" Thinking I need to switch off the automupdate when opening and then have a manual auto update. this way the module will run ??? loads of pivot tables to switch off over 50 connections. any ideas...

.xlsm error : unable to get to the Open Property of the workbook class Code : 800A03Ec Line 11: Set oStats = oExcel.Workbooks.Open("H:ReportsStatistics DataDashboard.xlsm")

Hi all, I have loads of modules in an excel spreadsheet (Dashboard) that I run via vbscripts. They all work fine in excel 2003. they bypass the pivottable updates (as the dashboard is connected to an access db. - excel : refresh data when opening a file) I have upgraded to 2010 and none of...

many thanks both of you..... before all I could see was alot of , and " I can see clearly now.. I feel a song coming on !! gonna be a bright sun shinny day...

Many thanks again. another tick in the box for an excel ninja. Will (fun) test again.

Hi Shriva, I did try this program and it works fine for the multi additonal lines. What I also would require on your version of the program would be "tail" added to the titles (same as JB's final program and also symbol , after the end of each rows. Can you advise on the adjustments to your...

Best Idea would be the amount of columns is equal to the amount of title cells (plus of course the tail) Sound like we are chasing mice....!!! Do you have a solution also what is the best design way. a) Const kiColumns = <random> based upon titles entered. or b) Const kiColumns...

Yes I understand. it was an ideas to give back to you all for the time and energy you have put in to my work and learning experience. Many Thanks for letting me know the possiable developments of the web site. its a 5 star web site with 5 star people....!!

Hi JB, If I wanted to make my program more flexable (Yoga Classes for VBA!!!) I would have your program plus a new sheet and cell where a person could enter how many columns required. enter the additonal titles and nformation in and then run your program. The cell entry box would be on a...

Hi, I think this web site is amazing. I work with Stats, VBA programs, Automation in my work and when I am unable to gain a solution I have found every time you guys know the answer and give your time and energy to help guide me and/or do the programs for me. I was looking at the web site...