Hiding "0" values in pivot table
In a worksheet I have a listing of stock records with ItemNumber, Date,
StockLocation and NumberOnStock. When I make simple Pivot Table with
ItemNumber and StockLocation as rows and select a Sum of "NumberOnStock"
I would like to hide rows where the sum is "0". But this does not seem
to be possible.
Tried to follow the guidelines in the Microsoft article:
But no luck :-(
You could use conditional formatting on these cells - highlight the
cells,...Pole Display does not update with Multiple Tenders
I've searched the board and can't seem to find any hints for resolving for
When we tender a transaction the total shows up on the pole display just as
it should. If the customer pays part of the total in cash the pole should let
them know the remainder, am I right? As it stands now it just displays the
total continually. This is primarily a problem as we have a tender set up for
"Manufacturer's Coupons" that we use to apply discounts outside our system.
Still, I would think that a running total should be available to the customer
regardless of wha...To get the same header,footer and sheet titles across multiple sheets of a workbook.
I want a workbook to have the same header (as some cell value of a
sheet in workbook) and similarly same titles (rows and columns titles)
in different sheets. I reached to the following code. It worked well
for the header (and also footer) but it didn't work for the rows to
repeat at top or columns to repeat. It only works for the active
sheet. How can i make my work done?? The main problem i think is to
make ActiveSheet.PageSetup.PrintTitleRows work across multiple sheets.
Please help me. I have the code attached here for yur reference.
'this is the workbook c...Hiding formuals in cells question
Hi. I was wondering if there was a way to hide the formulas in cells without
protecting the sheet. I am making something for other teachers at my school
and I want to hide the formulas so they won't mess anything up on the
spreadsheet. Any help would be greatly appreciated. Thanks!
not without protecting the sheet but why is this a problem for you?
"JP" <JP@discussions.microsoft.com> schrieb im Newsbeitrag
> Hi. I was wondering if there was a way to hide the fo...Charts in Multiple Sheet in Excel
I am new to the VBA programming & I am trying to develop a VBA script
which will create charts (as a separate worksheet) for each worksheet
in a workbook.
For i = 1 To Sheets.Count
ActiveChart.ChartType = xlColumnClustered
ActiveChart.SetSourceData Source:=Sheets("Sheet(i)").Range( _
ActiveChart.Location Where:=xlLocationAsNewSheet, Name:="Oxygen
.HasTitle = True
.ChartTi...Date-orientated update of cells in different spreadsheets
Dear Excel experts!
Hope I am right here...
I would like to create a customer-orientated & task daily checklist.
Basically, I want to have a single spreadsheet (spreadsheet1) and worksheet
(worksheet1) with customer names along the left (1 per row) and tasks along
the top (1 per column) which I update on a daily basis. Once the task has
been performed for a customer, a value will be written in the appropriate
field i.e. for customer1, the task1 result "passed" would be typed into B2,
however, for customer2, task1 might have "failed" which would be typed into
C...Data displayed that is not equal to FALSE in a row
In row 1 cells A1-D1 contain formulas (IF/AND statements). In cell E1 I want
whatever word that is not equal to “FALSE” to be displayed.
A B C D E
1 FALSE FALSE Under FALSE Under
The words can appear in any of cells A-D in each row as below.
A B C D E
1 FALSE FALSE Under FALSE Under
2 FALSE On FALSE FALSE On
3 Over FALSE FALSE FALSE Over
4 FALSE FALSE FALSE On On
Thank you in advance for your help.
Gary''s Student - gsnu201001
Thanks Gary. That works great!
"Gary'...How do I combine multiple org chart files into one Visio doc?
I want to take 9 individual Visio org chart files and combine them into one
file for saving them all together as web page.
New to Visio and just need a little help.
Select everything on a page and then Copy / Paste it to a blank page in your
other document. There really isn't a fancier way to do it.
This posting is provided "AS IS" with no warranties, and confers no rights.
"NC_Steve" <NCSteve@discussions.microsoft.com> wrote in message
>I...Multiple Conditional Formatting rules
Can anyone tell me how I can set 20 rules for conditional formatting o
What I need to do is colour a spreadsheet with 15-20 colours accordin
to a (different) spreadsheet full of numbers, so that eg 1 = red, 2
pink, 3 = blue, 4 = green..... etc...
Any help would be much appreciated.
Message posted from http://www.ExcelForum.com
this can only be done with VBA. Put the following code in your
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Intersect(Target, Me.Range("A1:A100")) Is No...Setting Cell Color within a Cell
I'm using quick test professional which uses Excel
DataTables, but with half the functionality. I'm
basically exporting a the datatable from Mercury quick
test to excel. With in my quick test script I'm
performing a compare between two excel documents, and I
wish to represent the difference with a Red background.
Basically, Is they anyway in which I could add so code
within my cell that would automatically change the back
My result is 4.13. I would then change this variable
within quicktest to something like vbRed.4.13. Then when
it gets sen...HELP: big problem with Excel, source cells, crashing and general madness
I have been on microsoft.public.excel.crashesgpfs but so far just the
one reply (from someone who has exactly the same problem as we do and
has not yet solved it either).
Anyone here can help???
My boss has this massive Excel spreadsheet with a number of worksheets
linked with other spreadsheets etc.
He is using Excel 2000 on Office 2000.
His computer was crashing with the above whenever he tried to do work
on it. We bought him a brand new computer, 1 gig of RAM, 80 GB of HDD.
We're a small company - a charity - so this was as powerful as we
This was a week ago and it...Multiple SOP Windows
Is there a setting in version 7.5 software setup that allows one user to have
more than one SOP window/document open at one time. If not this is simply
very poor design. Without this ability it is very cumbersome to handle say
periodic customer inquiries and at the same time work at another task such as
new order entry. One should simply be able to flip from one window/document
You can launch another GP session; although, that will use another user
For inquiries, could a person not use the Sales Document Inquiry to look up
...Printing Shaded Cells
I suddenly can't print out the cells that I have shaded with grey with my
black and white printer. It shows it in Print Preview but then it doesn't
print the grey. HELP!
Usually it will print what shows in preview. Probably related to printer
Did you try it before?
> I suddenly can't print out the cells that I have shaded with grey with my
> black and white printer. It shows it in Print Preview but then it doesn't
> print the grey. HELP!
Yes, I have lots of experience with Excel. It turns out I have to shade the
cell w...Automatically Highlight Every Second Row in Excel
I would like to know if there is any way to have excel automatically
highlight every second row in a sheet to make it easier to read accross the
Can you use conditional formatting?
If yes, see Chip Pearson's site:
> I would like to know if there is any way to have excel automatically
> highlight every second row in a sheet to make it easier to read accross the
...How do I stop cells from expanding?
Hey all. Just got Excel 2003, and have a real basic question.
I'm working in large files with very long cells, and everytime i click into
one to edit it, it expands to take up almost the entire screen. Problem is, i
need to look at cells in other columns, and this is a huge pain. How do i get
it to stop?
Thanks in advance!
If it is the formula bar that bothers you can turn it off temporarily under
"frodomojo" <email@example.com> wrote in message
news:FD91C628-9456-454D-9E2A-EF42F6F7F494@microsoft.co...hide my name
When replying to an email or creating one from scratch how do i hide my name
in the "from" field...thx
fred <firstname.lastname@example.org> wrote:
> When replying to an email or creating one from scratch how do i hide
> my name in the "from" field...thx
Are you saying you want the reply to be anonymous?
Brian Tillman [MVP-Outlook]
no, I don't mind if my email is revealed.. just my name. I have tried by
removing it from the "User Name:" field in the email account but it
continues to show up. I have also removed from the header informati...Hiding and Un-Hiding Data fields
I am using a form for people to select data via dropdown menus and then
having it run through a query to filter results. Is there a way that I can
have certain feilds hidden until a toggle button or something of the like is
Basically I want have three choices of buttons: Year, Quarter, and Month.
What I ideally want to happen is when someone selects the button for year, a
hidden drop down menu appears where they can then choose from the available
years to filter through the query.
I would say I am above average with using access, but I have no idea how to
hide fields and then...How to get rows from 4 diff permitations??
Wondered if you could help.
I have 2 tables of data like so:
TID PID YEAR TERMID MATHSLEVEL READLEVEL
1 1 2006 0 W1 W2
2 2 2006 0 1B W4
3 3 2006 0 W1 W2
4 4 2006 0 2C 5A
5 1 2007 1 W1 W2
6 2 2007 ...Put Active Worksheet's Name in a Cell #3
Is there a way to put the active worksheet's name in the cell? Not the
file name of the whole workbook, just the name of the currently
Thanks for your help.
There are a few ways this can be done using either macros or functions,
here's one of each:
(sourced from Chip Pearson's site, http://www.cpearson.com/excel/excelF.htm)
I recommend checking this page out as it also shows ot...How do I hide gaps in an Excel 2007 chart?
I have a bar chart that is showing gaps and i don't want them. The select
data > hidden and empty cell button does not give an option to hide gaps. I
think by default they are hidden but if you even click on this to see what it
does the gaps are shown and no way to turn off.
If you hide the actual rows then with the Plot visible cells only
setting on the gaps will be removed.
In xl2007 the setting is on the Select Data dialog, Hidden/empty cells
> I have a bar chart that is showing gaps and i don't want them. The s...How to enable auto height with merged cells?
I previously asked a question regarding auto height with merged cells and was
given a code to enter into visual basic. I entered the code and copied &
pasted a narrative into the row. It originally seemed to work. But after
closing the workbook and re-opening it another day the 'referenced' row is
back to the original height.
Is there a way to for the row height to expand and remain sized so anyone
accessing the workbook can read the narrative? Additionall, I need the row to
remain at the full height when printing the worksheeet.
...multiple duplication of records
Could anyone assist me with the following:-
I have been using the quick reference search tool that can be found at
Using only one table with no problems however I am now trying to use it in a
Two tables linked back to the main table via one too many links.
What is now happening is that multiple duplication of records are being
If you have one table with two records the listbo...Hiding a worksheet #3
I want to hide a worksheet. So, I went to the format menu and the "worksheet" option is grayed out. Why? And, how do I "ungray" it.
is your worksheet protected ?
> I want to hide a worksheet. So, I went to the format menu and the
> "worksheet" option is grayed out. Why? And, how do I "ungray" it.
I think Frank meant to ask about the Workbook--not the worksheet.
(Check under Tools|protection|Protect workbook or Unprotect workbook)
My question is: Is there another sheet in the w...Print multiple non-sequential pages?
Having been playing around with various printing methods for the past week
or so, I'm noticing that I don't see any method to print via VBA a set of
pages in a non-sequential order...
DoCmd.PrintOut offers us a Range to work with, but how about particular page
Ex. Pages 1-4, 9, 15
Is the standard method for this to use PrintOut 3 times, one for 1-4,
another for 9, and another for 15? I don't see any reason why I couldn't do
this, but was wondering if the feature is built-in somewhere and I haven't
...Skip multiple blanks
The following details will skip blank cells in a range so that when creating
a custom validation list there will be no blanks.
BA4:BA500 contain customer names
BB4:BB500 contains the formula:
BC4:BC500 contains the formula:
Defined range with the name SkipCustomerBlanks:
When a customer name is deleted in BA the range BC4:BC500 then...