I have a problem here guys.
I have a worksheet that contains data from 7 different drop down lists.
One of these drop down lists is in 10 different columns. And another is in 6 different columns.
I would like to add all of them to my pivot table, to analyse the data collected from 526 different question forms.
How to do this?!
Or is there another, better way of doing this? Please help!
Hi friends!,
I have a data file, and another file with some pivot tables on different worksheets, each reading from the data file.
I am trying to write some code in the data file that tells the relevant pivot table to refresh anytime data changes in the source table. What I wrote doesn't work. I have pasted a sample of what i came up with, below.
Private Sub Worksheet_Change(ByVal Target As Range)
[file_name.xlsm] worksheet_name!.PivotTables("PivotTable1").RefreshTable
End Sub
Could anyone help me correct this code, or give me a better way to do this?
As always, I am very grateful for any ideas and suggestions.
I have a pivot table with a bunch of sales data split into 3 worksheets (so 3 tables.) This file is 65 megs and takes about 2 minutes to open.
1. Is there a better way of doing this? Access database? On our intranet w/ a database background?
2. If I pick a customer on pivot table 1, worksheet 1, can vbscript choose the same customer on all on worksheets?
3. Any way to speed it up if I don't move to option 1 above?
4. Should I create the pivot tables and pull data from Access?
Thanks!
How does the term 'pivot' apply to Excel's Pivot tables and Pivot Charts
Here I want to know whether i can get the Distinct or Unique Count of the different User ids
within the same Journal Entry Number column.
Example The pivot table has MTX-10001158 Journal Entry Number has
USER95
USER94
USER95
USER94
in the line and grlines level.
so i want count=2 for User id USER94
and count = 2 for User id USER95 within the same Journal Entry using Pivot table and so on for all the Journal Entry Numbers.
That is Distinct count of different user ids within the same Journal Entry Number using pivot table and
if possible the sum of count of user ids distict count.(example count =2 for user94 and count for user95 is 2 so sum is 2+2=4)
Please help me with this query.
Thank you.
Hi
Within my macro is some code which sorts 4 pivot tables on a worksheet. Elsewhere in the macro one can select the filters required on the pivot table which refreshes the pivots. However if a filter is selected that contains no data the Macro falls over on whichever pivot does not contain the data.
I guess I need an IF statement around the autosort lines of code supplied below which will move on to the next line if there is no data in the pivot.
ActiveSheet.PivotTables("PivotTable4").PivotFields("CLIENT_NAME").AutoSort _
xlAscending, "Sum of RANK_AREA", ActiveSheet.PivotTables("PivotTable4"). _
PivotColumnAxis.PivotLines(1), 1
ActiveSheet.PivotTables("PivotTable5").PivotFields("CLIENT_NAME").AutoSort _
xlAscending, "Sum of RANK_SECTOR", ActiveSheet.PivotTables("PivotTable5"). _
PivotColumnAxis.PivotLines(1), 1
ActiveSheet.PivotTables("PivotTable8").PivotFields("CLIENT_NAME").AutoSort _
xlAscending, "Sum of RANK_LBC", ActiveSheet.PivotTables("PivotTable8"). _
PivotColumnAxis.PivotLines(1), 1
ActiveSheet.PivotTables("PivotTable7").PivotFields("CLIENT_NAME").AutoSort _
xlAscending, "Sum of RANK_SECTOR_LBC", ActiveSheet.PivotTables("PivotTable7"). _
PivotColumnAxis.PivotLines(1), 1
Please help
Thanks
Charlie
Hi folks,
I'm looking into alternatives for excel to use in a company to create marketing reports, dashboards and analysis from data held in a mySQL database.
Does anyone have a positive recommendation at solutions to look into? Currently looking at JasperSoft and Pentaho type solutions as a possibility.
Cheers,
James
I have put together a spreadseet and posted it online for the use of work
colleagues. A few of them have reported to me that they don't have excel on
their computers, is there another program around that will allow the opening
and editing of excel spreadsheets, i have looked at excelviewer and
currently have a link to openoffice on my website but feel this is
unnecassarily large for my purposes and i would be very happy to find a
program that will do what i need and that is up to about 10Mb in size.
i'm not sure if this has been asked before, but my search didnt reveal any good info. thus my question is this:
for all you excel gurus, do you know any alternatives to using spreadsheets? (ex: anyway to recreate excel functionality on a web page, ms access, etc) that would allow the user to do pretty much the same things that you do in excel (ie. resize/add/delete/mask columns/rows, dynamic formulae, etc). perhaps even a commercial program?
the reason im trying to move away from excel is the fact that my file has become very big (>4mb), caused by the fact that i use alot of external references and one of the links points to a table of around 10000 rows by 40 columns.
also, needed is the ability to automatically update its data from an existing DB (reflecting any live changes) without the user having to manually update any source excel files.
basically, in the end, i need a file/program/web page that has an excel look and functionality and that fetches its info from a DB upon user input (ie. i enter a product number and i get its name, description, price, etc) and that it be small(ish) in its size and easy and fast to use.
there! lol ! im not sure it even exists but if any of you have came across similar needs and found various solutions, i would gladly listen to you
thanks in advance !
p.s. im fairly proficient in programming (VB, C#, as well as html et al.) so if you have examples of codes, etc, dont be shy
I have an excel spreadsheet which uses data validation and the INDIRECT function a lot.
Unfortunately, Microsoft's Pocket Excel dosn't support data validation so can anyone recommend a good alternative?
