Excel XP Subtotal method not working
We have a workbook that was created in Office 2000 that contains a
macro that performs subtotals on a range. We have several machines in
our company that are running Office XP (various OS) and are having
problems with this workbook/macro. In Office XP, the subtotal method
does not work. Before adding code to the macro to stop screen
updating, the spreadsheet would lock up. Now this doesn't happen but
the subtotal function is not working properly. This happens on each
Office XP machine.
Thanks in advance.
I had the same problem with my macros when i transfer them from exce...Subtotal in a report
I have a report I'm building to give me activity by category. Within the
report I have information like Inventory on hand, inventory in transit, on
order, etc (by month).
I'm looking to be able to add a subtotal in the report for total inventory
for each month. What's the best way to calculate this?
Please post the SQL statement you are using to "feed" that report.
"How" will depend on "what"...
Microsoft Access MVP
Disclaimer: This author may have received products and services mentioned
in...expand and collapse
Does anyone have any directions or examples of how to do a drill down button
on a form. I want to have a topic and when the user pushes the + sign it will
open forms or command buttons related to that topic and then of course I
could collapse the button as well. Any suggestions would be helpful. It would
work similar to this website or a pivot table.
What you describe sounds like the Windows Tree View Control.
There are quite a number of references in former MVP, now Microsoft
employee, Jeff Conrad's "Access Junkie" website...
http://www.accessmvp.com/JCo...How do I resize shape in powerpoint (resizing collapses the shape
I can draw a shape in PowerPoint 2007 but when I click on it to change the
size, it collapses vertically. I can stretch it horizontally but can't
change the vertical height.
Have you applied all the hot fixes and service packs to PowerPoint 2007?
There were issues with this early on, but most have been resolved with the
"jmmarq4" <email@example.com> wrote in message
>I can draw a shape in PowerPoint 2007 but when I click on it to change the
> size, it...Programmatically Expand or Collapse a sub menu
Does anyone know how to do this on a CMenu object?
I'm working on a RClick feature for a CMenu. I've got to the point now
where, while the menu is displayed, I can Right click on a menu item
then that item will automatically be converted to a SubMenu and the
little arrow on the right side appears - this all happens automatically
while the menu is still displayed.
Problem is that I have to move the mouse over, in order to display the
new submenu. I would like for the submenu to be displayed
automatically, after I've added it.
Is there a hidden method on CMenu that I can't see...How to prevent automatic collapsing of "inner" folders when collapsing "outer" folder in Outlook 2003?
In Outlook 2003 I created a big private folder tree where I store all my emails according to the topic.
Assume I expanded all the folder so that the "inner" folders are all visible in the tree.
Now I collapse the outermost folder and re-open (re-expand) it again immediately.
I expected that the collapse/expand state of the "inner" folder is kept.
Much to my surprise this is not the case. ALL folders are collapsed and I have to re-open them
all manually again. This is very un-convenient.
Is there an option to prevent this automatic collapsing of inner mail folders?
Sven...Subtotals or PivotTables
In the following example:
For Item "a": I need subtotals of $418.38 for "CA", $67.78
for "NV" and $97.70 for "AZ" plus the total of $583.86.
For Item "b": I need subtotals of $202.16 for "ME", $33.90
for "VT" and $48.84 for "OK" plus the total of $284.90.
Item State Price
a CA 81.08
a CA 82.70
a CA 83.68
a CA 84.62
a CA 86.30
a NV 13.54
a NV 13.56
a NV 13.56
a NV 13.56
a NV 13.56
a AZ 19.54
a AZ 19.54
a AZ 19.54
a AZ 19.54
a AZ 19.54
b ME 39.18
b ME 39.96
b ME 40.44
b ME 40.88
b ME 41.70
b VT 6.78
b VT 6.78
...Pivot Table Percentages for Subtotals
In a Pivot Table I am trying to get Percentages of a subtotal such that
the subtotal is 100%. See Below. I would like to maintain the
format. I can get to the results before the %. That is the left 3
columns. I thought I could get the percentage with "Field Settings
show data as:" command. But I have been unsuccessful. Any help
would be greatly appreciated
1.Total..........Subdocuments is always collapsed when opening the masterdoc
I saved a masterdocument with all the subdocuments expanded. When I reopen
the masterdoc, the subdocuments are always collapsed however. As I want to
distribute this file and I am afraid that not everybody is used to working
with subdocuments, I want the subdocuments to appear automatically expanded
in the masterdocument.
As far as I know, you cannot change that behavior.
More importantly, though, the master document feature in Word causes
document corruption; see
http://word.mvps.org/FAQs/General/WhyMasterDocsCorrupt.htm. For a safer
approach, u...Subtotal data excluding negitive numbers.
I have a spreadsheet contains lots information, each one linked to
some other spreadsheet. In column =93A=94 some numbers are positive and
some are negative. What I want to do is to subtotal(9,A3:A100) to show
the total numbers when I filter something out. While I don=92t want
these negative numbers to be calculated. I knew if I add a new column
can resolve this problem, but if I the spreadsheet does not allow me
to do that change, how can I put kind of formula in one single cell to
show the subtotal result without adding the negative numbers?
I have tried sumproduct but result only ...Outlook 2007 collapsed folders
Its minor but annoying. For some reasons my folders (e.g. inbox,
unread, etc.) have an initial collapsed view requiring me to always
have to click the '+' sign.
If new mail comes in I cant see the header right away until I
uncollasped the folder. Did I change the default view somewhere?
firstname.lastname@example.org <email@example.com> wrote:
> Its minor but annoying. For some reasons my folders (e.g. inbox,
> unread, etc.) have an initial collapsed view requiring me to always
> have to click the '+' sign.
What tye of account?
On Thu, 9 Aug 200...Collapsible lists
creating a collapsible list in FrontPage 2003. Can anyone give me something
to copy & paste, and tell me where to insert it?
and take your pick.
Tom [Pepper] Willett
Microsoft MVP - FrontPage Since 1997
"Confused by FrontPage" <ConfusedbyFrontPage@discussions.microsoft.com>
wrote in message news:8C3B1C65-5E12-458D-A754-09B2FD90949F@microsoft.com...
personally i would sort the data by the category on which to subtotal
then subtotal it (data / subtotals)
then collapse it down so i could only see the subtotal lines
choose edit / goto / special - visible cells only
go to a new sheet & paste
then sort that list.
hope this helps
"Steve_Wood" <Steve_Wood@discussions.microsoft.com> wrote in message
Just hide the details and sort the visible cells.
when you show the details, you'll be amazed (I was!) that exce...Collapsible Panel
I am trying to develop a collapsible panel using MFC (without
..NET). But So far no improvement. Google has lots of applications using
..NET. But how do i develop collapsible panels using pure MFC?
"Collapsible panel" is quite vague. What exactly are you
talking about. Details please.
"Daya" <firstname.lastname@example.org> wrote in message news:email@example.com...
> Hi All,
> I am trying to develop a collapsible panel using MFC (without
> .NET). But So far no improvement. Google ...Pivot Table Question
A couple questions concerning my pivot table. Can I have subtotals in my
pivot table, and if so, how do I do it?
Larger fund entities are required to file 13F documents, which reveals their
holdings, each calendar quarter. In my situation, I am tracking which funds
own Stock ABCDE. The 13F documents are filed quarterly and it shows how
many shares are owned by a) sole discretion and b) share discretion. A fund
can own ABCDE shares in both the sole and share discretion categories.
My pivot table has the following layout.
1) Dates (quarterly data) - Column.
2) Fund Companies - Row
Is there a way to use the subtotal function on the tools menu to have a sum
and avg in the same subtotal line? For instance you may want to total one
column and avg another column all on the same row.
Create one subtotal using that method, then copy that formula acroos, but
change the 9 to a 1
"JJ" <JJ@discussions.microsoft.com> wrote in message
> Is there a way to use the subtotal function on the tools menu to have a
> and avg in the same subtotal line? For instance you may want to total one
&g...Collapse a report
I just finished a custom report, but I want it to default to the collapsed
view. Is there a way to do that?
after you generate the report, collapse it and the memorize it. the next
time you generate that memorized report it will open collapsed.
"Rick@ASP" <RickASP@discussions.microsoft.com> wrote in message
>I just finished a custom report, but I want it to default to the collapsed
> view. Is there a way to do that?
It didn't work. The memorized one looks just like the original.
...Date format collapses diagram
I have a strange problem which is different to explain.
I have a workbook with five sheets containing data and a cell with
a date in it. A sixth sheet contains a table with data collected
from the first five sheets, with the dates as categories, like
08.2004 09.2004 10.2004 11.2004 12.2004
3 4 4 5 3
4 3 5 4 4
3 2 5 3 4
The table is used for generating a line diagram. Now, the diagram
looks fine when I only include data and categories from the first
four columns. If I inc...Inbox folder automatically collapsing
I have Outlook 2007 and the Inbox folder under All Mail Items>Personal
Folders>Inbox is normallly expanded at all times so I can see all the
sub-folders. For some reason it started to collapse every time I delete a
message in the View column or minimize my Outlook window. It just started
today and I have no idea why or how to correct this without having to
constantly expand the Inbox folder after every deletion, etc.
Have you tried restarting outlook or rebooting?
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solu...How do I collapse a menu in Excel
Is this question as basic as I think? Is the question asking me to minimize
the Window? I have looked through all the option but do not seem to find a
function to "collapse"
Click anywhere other than on the menu and the menu will colapse
> Is this question as basic as I think? Is the question asking me to minimize
> the Window? I have looked through all the option but do not seem to find a
> function to "collapse"
...subtotaling worksheets #2
very vague, I'm afraid ... any ideas
GazMo's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1461
View this thread: http://www.excelforum.com/showthread.php?threadid=27025
I'm not sure whether I am intrepreting what you want correctly. I thin
you want to create subtotals on each page and then copy the subtotals a
the bottom of the page.
For each worksheet you could:
1. create the subtotals - use absolute cell references, specify Jan-De
2. loop through the rows to f...Collapsing Cells
I have a spreadsheet that has data I want to extract that resides in
every 4th cell down. So for example:
Row 1 - Name
Row 2 - Address
Row 3 - City State Ziop
Row 4 - Phone Number
It is row 4 I want to extract and I am looking for a way to extract
ONLY the data in each 4th row into a spreadsheet that will have all
phone numbers listed.
In A1 of Sheet2
Gord Dibben MS Excel MVP
On Mon, 26 Apr 2010 10:35:10 -0700 (PDT), Kip <firstname.lastname@example.org> wrote:
>I have a spreadsheet that has data I want to...Whitespace collapse not working on XmlValidatingReader?
I need an attribute (could be an element too) to have its whitespace
collapsed . I don't get the expected behavior, however.
The schema is as follows:
<xs:whiteSpace value="collapse" />
...Adding Formulas to Subtotal rows
I have a large amount of data on a spread sheet which has been sorted and subtotaled (using the “Subtotal” function on the data menu). On each subtotal row I would like to have formulas that use the results of that row’s subtotals (ie divide the value of one subtotal by the value of another subtotal on the same row). At the moment I am creating the formulas on one subtotal row and then copying them to each of the remaining subtotal rows – one row at a time. This seems to be cumbersome – is there a faster way?
one way: use a formula like the following
=IF(ISNUMBER(FIND("Tota...Keep folders collapsed
Why can't I set Mail just like OE was? I don't want the folders open except
for the ones that contain an email that hasn't been read yet when I first
Thank you for your kind response,
"Just Me" wrote:
> Why can't I set Mail just like OE was? I don't want the folders open except
> for the ones that contain an email that hasn't been read yet when I first
> start Mail?
> Thank you for your kind response,
> Just Me