|
|
Refreshing pivot table when cut/paste data by
Martha
I think this is supposed to be easy, but I'm having
trouble. I have a pivot table that is run off data called
Source. I need to replace the Source data on...
|
|
1 |
550 |
|
|
|
July 2nd, 2004 02:52 AM
by Max
|
2 |
171 |
|
|
Subtotal by
George Gee
Hi all.
I have formula in A2 =SUBTOTAL(3,A4:A2963)
this counts the number of visible records, (after using Autofilter),
that contain text (ignores blank...
|
|
6 |
126 |
|
|
Inserting EXCEL into WORDS by
Lee
Hello! Friends:
I try to insert an EXCEL worksheet into WORDS by using (in
WORDS)INSERT/OBJECT/CREATE FROM FILE/(XL filename).
The inserted XL worksheet...
|
July 2nd, 2004 01:07 AM
by CLR
|
9 |
160 |
|
|
|
July 1st, 2004 10:36 PM
by CLR
|
2 |
112 |
|
|
Comment box by
tghcogo
When I insert a comment, already inserted is "User:", is there a way to
get rid of this so that the box is completely empty?
---
Message posted from...
|
|
3 |
160 |
|
|
Fonts unavailable for symbols by
Dianah
I'm trying to insert a symbol from a font, however, when I go through the
steps , ... I click on the font field pulldown menu and the
fonts only go to what...
|
|
2 |
226 |
|
|
Applying a Header to Workbook by
Kerri
How do I apply a header to an entire workbook? What I
really want is for the header to print on every page. I
would also like the page numbers to appear as...
|
|
3 |
160 |
|
|
make command button invisible by
Excel-VBA Dummy
Could someone please tell me the syntax to make a command
button visible or invisible?
I was hoping it would be something easy like:
commandbutton.visible =...
|
July 1st, 2004 01:42 PM
by
|
5 |
145 |
|
|
Match one column to another? by
bobfronk
Ok, I am not an Excel person, but as the IT manager I have been asked to
help someone with a spreadsheet.
A SQL database is queried. It returns information. ...
|
July 1st, 2004 12:30 PM
by JulieD
|
1 |
115 |
|
|
Blank rows between data by
sdrendon
I have a spreadsheet with blank rows between each row of data. First of
all, how can I set it up to skip the row automatically when entering
and second, when...
|
|
1 |
133 |
|
|
Condition by
lolita
i have 2 problems :
1) i need a formula that will put me 20 if the day is 18th of each month of the year 2004
2) i need a formula that will put me 205 every...
|
July 1st, 2004 12:21 AM
by CLR
|
1 |
113 |
|
|
adding worksheets by
craig
I am trying to add a worksheet to an existing excel workbook, but under the insert tab "worksheet" is greyed out. What is the deal?
|
June 30th, 2004 10:07 PM
by Paul B
|
1 |
95 |
|
|
Logical pivot table by
dk
Is there anyway to create a logical field and a pivot table for ex: colmun d is going to be a logical T. F. column E is going to be figures which is going to...
|
|
1 |
104 |
|
|
2 decimals by
Elsa
Are you sure that you need all those decimals in the
original worksheet/workbook?
If you don't, you can round them (or truncate them) to the
proper 2 decimals...
|
|
1 |
121 |
|
|
|
|
1 |
273 |
|
|
|
June 30th, 2004 11:00 AM
by ANZAC
|
4 |
114 |
|
|
Save as Web Page for Excel 2000 by
Peter
I am new to Excel 2000 and attempted to save an Excel
Document as Web Page that can be changed interactively.
However, when I change the content in that...
|
|
1 |
129 |
|
|
Returning the price of an item by
Randell Gower
I need to have Excel return the price of an item when I enter it. I work
with lists and I frequently type in an item and then I manually enter a
price for the...
|
June 30th, 2004 04:32 AM
by Biff
|
2 |
122 |
|
|
Random Number Macro by
ken ogden
Hi,
Does anybody have, or are smart enough to write, an excel macro that will
produce random numbers WITHOUT duplicates. I can't see to get my head...
|
|
2 |
155 |