Sorting in pivot tables
Any web-sites/guides discussing Top 10, descending sorts and the like using
pivot tables in Excel. These functions always seem incredibly tempremental...
...Memory usage in XP (memory leak detection)
How can I found out the memory usage on XP ? My XP box uses over a week all
memory and then has no resources available. It has 4GB memory (3.5 GB free)
I used typeperf with the following:
\Memory\Pool Paged Bytes
\Memory\Pool Nonpaged Bytes
\Memory\Cache Bytes Peak
\Process(_total)\Virtual Bytes Peak
\Process(_total)\Working Set Peak
\Process(_total)\Page File Bytes Peak
\Process(_total)\Page File Bytes
\Proc...not enough memory on excel 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
<i>run excel 2008 on mac snow leopard 2 g memory i upgrade to 3 g and same</i>  message not enough memory can some one help me only word working
Run Remove Office then re-install Office
On 30/03/10 7:08 AM, in article 59bb629f.-1@webcrossing.JaKIaxP2ac0,
"Snow_leopard@officeformac.com" <Snow_leopard@officeformac.com> wrote:
> Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
> run excel 2008 on mac snow leopard 2 g memory i upgrade t...Pivot table data dissappears
I am using data from an Excel sheet (Excel2003 sp1) that is on the same page
as my pivot table. It works exactly as I want it to whenever I click on
different categories from the dropdown boxes attached to "page," "column" or
"row." It also works when I use the "data" dropdown box; that is, I
eliminate some of the categories of data BUT when I click on the "data"
dropdown arrow again, the categories that I deselected are no longer shown
and I must drag the missing data category from the feild selection box to the
pivot table in order t...Tables and Relationships Question
I'm wanting to generate evaluation forms for student assignments for a series
of dates. So far I've created the following tables:
The problem I can't get my head around is how to handle the table structure
and relationships for the series of dates on which the student will be
training on the assignment. Using a report, I'd like to generate one
evaluation sheet per student for each of the 7 dates they will be pe...Grouping In Pivot Tables #3
I have a pivot table linked direct to an access query. In the pivot table I
have grouped the date field by year & month and set the start date as 1 Apr
2005 and end date as 31 Mar 2006. Some of the months have no data so I set
the field settings to 'include items with no data' however, this then shows
blank fields for Jan, Feb & Mar 2005, if I try filtering or hiding them out
it also hides Jan, Feb & Mar 2006.
How can I get it to only show from Apr 05 to Mar 06 and include fields where
there was no data between those dates?
Uncheck &quo...Pivot Table Error Message
I received the following message when dragging my "Products" item onto my Pivot Table.
"A field in your source data has more unique items than can be used in a Pivot Table."
I have 14,802 unique Product items. Does anyone know what the limitation is AND how to get around it?
The following MSKB article outlines the PivotTable limits in Excel 2002,
and has links to articles on other versions:
XL2000: Limits of PivotTables in Microsoft Excel 2000
XL2002: Limits of PivotTables in Microsoft Excel 2002
http://supp...Pivot Tables 01-22-10
Operating System: Mac OS X 10.6 (Snow Leopard)
Hello, <br><br>I have a Pivot Table based on a 5,000 row table which creates a 500 item drop-down list of names which is in alphabetical order. <br><br>I would like to be able to type in the first letter of a name into the drop-down list (or any other drop-down list) and then to choose a name from the shortened list of names beginning with that letter. <br><br>So instead of scrolling through 400 names to get to names beginning with "S", I could just type in &...when replicating, I get error message, but there is no table
when replicating with my assistant, I get that there are replication errors,
but when I try to open the conflicts table, I get that there are "no conflict
=?Utf-8?B?YmttNGVhZ2xl?= <firstname.lastname@example.org> wrote
> when replicating with my assistant, I get that there are
> replication errors, but when I try to open the conflicts table, I
> get that there are "no conflict tables"
You'll have to look at the tables directly. The conflict tables are
called BaseTabl...Stock Count Entry window - Captured, Counted qty vs
I have a problem, in which Captured qty of an item is different from
Captured Lot number qty. Basically the captured qty of an item is equal to
our counted qty, but lot number had less. Due to that we cannot post our
inventory. I found in the IV00300, there is on lot for this item and this
site, which is not captured in the captured information of the lot numbers.
That lot number was created during the reconciliation of the inventory of
that item. Why is doing like this? Does Microsoft has any answer for that?
I have run into this problem. For my site we ran both the Item...Database list vs pivot
I am following a tutorial to do a simple database list in excel.
The tutorial suggest me to do Data>List but in Data menu in excel
2000 I don't have list!!!!
Someone could tall me how to create a list with Excel 2000. If I
select Pivot start a wizard that cover with a mask my data
Data|List was added in xl2003 (IIRC).
It doesn't exist in xl2k.
Maybe you could use data|filter to see some of the features of data|list.
> Hallo everyone,
> I am following a tutorial to do a simple database list in ex...Is it a memory leak
I have used standard template library in one of my applications. I
belive that memory leaks are due to stl components, mainly string. i wrote a
sample program in VC 6.0 that clearly shows memory leaks in stl
wstring str = L"";
for( int a = 0 ; a < 100000 ; a++ )
str += L"int";
str.str.erase( str.begin() , str.end() );
str = L"int";
i wrote this code against a button in dialog based application. Before
clicking the button, the memory usage is 3MB and after this code it is 17MB
although i believe it should have been bac...What is the difference between table relationships and links?
I am new to Access & need to understand the differences between a link & a
relat ionship to a table or database. I am told the table must be created
before the database, but I need several tables for my data. I need to ensure
I use the correct method to allow me to create a database using the various
A link to a table is basically a connection path to a source of data that
exists somewhere other than the current Access application. The data source
can be to a table in an MS SQL Server, Oracle, a text file, an Excel sheet, or
anoth...update yes / no field in table based on another table
I am wanting to update a yes/no field in one table based on another table.
If the name is in both tables to put a "yes" value in the field
If the name is in one table but not the other to put a "no" value in the field
Table 1: Name
Table 2: Name
Check box = yes
Table 1: Null (Name not in table)
Table 2: Name
check box = no
On Mon, 3 Mar 2008 14:55:01 -0800, Bryan <Bryan@discussions.microsoft.com>
>I am wanting to update a yes/no field in one table based on another table.
>If the name is in both tables to put a "yes" va...Re-set autonumber in a table (primary key)
I have built a database and tested it thoroughly. I deleted the test records
but now my first record has an automunber or 15 and this is winding me up.
Can I re-set the autonumber back to 0?
Try a compact and repair on the DB (front- or back-end) having that table.
> I have built a database and tested it thoroughly. I deleted the test records
> but now my first record has an automunber or 15 and this is winding me up.
> Can I re-set the autonumber back to 0?
Delete the field. Save the table. Insert a new autonumber field
Manchester, Englan...Lines of text disappearing in Word Tables
Operating System: Mac OS X 10.5 (Leopard)
I'm having a weird issue with text within tables in my word document. For some reason, if I delete the last row of a table that I'm working on, the previous row's text disappears. What's even more strange is that the first line of text disappears if there are two lines of text in the row, and the second row is fine. <br><br>Any help would be greatly appreciated!
Sorry, not enough detail to answer.
1) Select the entire row and choose Edit>Clear>Clear Formatting.
Now what ha...Exchange memory utilization
Is there any documentation detailing the exchange 2003 memory utilization ,
especially in coordination with the max store size.
What do you want to know? Exchange will use all the memory it can in the
box, up to 4GB, for caching, and this isn't a function of store size. It
will release memory so that other processes can get what they need.
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"MSNews" <Craig@nowhere.org> wrote in message
> Is there any documentati...Lookup and tables
Orientation of collector
Tilt of collector South SE/SW E/W NE/NW North
Horizontal 933 933 933 933 933
30 degrees 1042 997 886 762 709
45 degrees 1023 968 829 666 621
60 degrees 960 900 753 580 485
Vertical 724 684 565 427 360
I need to make it so Excel will Lookup a piece of data in the above table
when someone writes in the Tilt of the collector in one cell, and the
orientation in another.
IE Tilt of collector: 30
Orientation ...Pivot Table Will Not Expand Beyond Ten Columns
I have designed a pivot table that I intended to update each month.
My data table includes a column for the date at the monthly level.
Until this month, it was working fine. As each month passed, I would
simply check off the new month in the drop down menu in the pivot
However, for some reason, when I select November, the table does not
expand one column. Instead, the table stays the same size, but drops
March data (though March remains selected in the drop down).
I've never come across this before. Any ideas what I'm doing wrong?
Is there still March data in the ...Create One Record in a New Table from several tables
I have 4 "master" tables of information - Agent, City, Dept, and Level. I
have a form that has a list box for each field in each of the 4 tables [4
What I need is: The User clicks to select the field information needed in
each of the 4 tables, then I want them to hit a command button and it creates
a new record in another table with the selected information.
Can anyone help me?
Would greatly appreciate it!
On Tue, 8 Jan 2008 10:00:03 -0800, DF2008 <DF2008@discussions.microsoft.com>
>I have 4 "master" tables of information - Agent, ...Text Effects: Word 2003 vs. Word 7
I sent a corrected document to a family member and where I made the
corrections I inserted text effects (las vegas lights). I have Word 2003 and
she has Word 7. Somehow the LV lights got saved to default in her word
program and now she can't remove it. Every new document she types has the
infernal lights surrounding the text. Does anyone know how to get that
permanently deleated from the default? Thank you.
On Wed, 9 Dec 2009 19:47:02 -0800, DertyChenchilla
>I sent a corrected document to a family member and wher...how to count columns i pivot table?
My pivot is dynamic, created with VB, and number of columns will vary.
I need this count in a variable for use in further processing.
Any assistance appreciated!
myCol = ActiveSheet.PivotTables(1).TableRange2.Columns.Count
"ulfb" <email@example.com> wrote in message
> My pivot is dynamic, created with VB, and number of columns will vary.
> I need this count in a variable for use in further processing.
> Any assistance ap...Out of Memory
I am using Excel 2000. Operating system is MS 2000. Ram
I am running a large Excel file 65,536 rows by 24 columns.
The columns may expand somewhat; say 5 extra rows as the
The Excel file links to another Excel file to do some
Some formatting is going on as well as Paste Special Value.
I get an out of error message and Excel stops.
If I only have 50,000 rows it works fine.
I have increased the virtual memory to the maximum, same
There are only 65536 rows in a worksheet. You cannot use
all the rows. Split your sheet into sevra...memory growing spreadsheet
I have another query-
For some reason when working on a spreadsheet it can
start with say, 925kb in size,I do a couple of changes,
then "Wolla" 10+mb
It only happens every now and again, but I have tried
copy then paste special, taken all macro's out, save as a
different name,copy sheet into different book, but still
can't bring it back down in size, "Hu" I even took my
changes back out
What is going on?
What are you doing? Whatever it is, I think I'd want to do something
else. But I haven't any hint what to avoid doing &...starting a pivot table
I've never done a pivot table before, so i don't really know what i'm doing. I'm trying to create one but the data i have isnt single rows. Instead it is chunks of rows and columns. For example, i have five columns and the first column has one thing under it, the next has one, but the next has three things and the next has one and the last has five things. But those are all one group of data because they all belong to whats listed in the first column. Can anyone understand what i mean?
It sounds like the data contained in the other columns are not 'linked' to