I have a pivot table tied to an OLAPcube. I need it to show rows when there
are zero sales for the products. I can't find any documentation on it. I
目前分類:title (3013)
- Oct 22 Sun 2006 20:09
Rows with zero values in Pivot table.
- Oct 22 Sun 2006 20:09
Excle should allow define a fix exponent in scientific notation
It would be bery useful that Excel could allow make a custiom format about
scientific notation where the exponent could be defined by user. For example,
- Oct 22 Sun 2006 20:09
Macro in Excel 2000
I have created a macro and saved it in PERSO.XLS.
Now, I want to remove that macro but I get the message that the file is in a
- Oct 22 Sun 2006 20:09
how do I change height of in-cell drop box list to 12 items
Having created a list, name, the data validation route to allow in-cell drop
down, I find that only 8 of the 12 items are listed amp; need to use slider bar
- Oct 22 Sun 2006 20:09
Macros are disabled
I have just started getting a message when I open any workbooks that macros
in them.
- Oct 22 Sun 2006 20:09
Stopping windows installer from popping up all the time
Hi recently had to install Windows 97 on my computer for my new employer. I
had to delete Windows 2000 to do it. Anyway, everytime I go to open an
- Oct 22 Sun 2006 20:09
Automatic Saved Date
- Oct 22 Sun 2006 20:09
Does excel acept arguments
I need Excell to execute the following:
If B5 is = zero then C5 is = to E5In cell C5, enter
- Oct 22 Sun 2006 20:09
If columns match
Is there a formula that I can use to see if numbers (some are Alphanumeric)
match. ie
- Oct 22 Sun 2006 20:09
IIF issue
I need to do the calculation according to the availability of data as
following example.
- Oct 22 Sun 2006 20:09
Help with time formula so the time will not change.
I am in need of help with a formula involving the time. What I need is for
the time to automatically fill in a cell when info is typed into another cell
- Oct 22 Sun 2006 20:09
additional month calculation
I have a starter cell with a month/year. Is there a way other than
date(year(),month() 1,1) to get the following cell to just add one to the
- Oct 22 Sun 2006 20:09
List Validation Improvement Suggestions
Hi,
I use the excellent list validation feature in Excel very often and in my
- Oct 22 Sun 2006 20:09
ADVANCED FILTERING IN EXCEL 2003
I've come across a problem with advanced filtering in Excel 2003.
- Oct 22 Sun 2006 20:09
Using a nested Address function for a reference
- Oct 22 Sun 2006 20:09
Anyone have a GPS Time conversion for excel
Need a weekly time conversion formula for GPS time to either UTC or standard
time
- Oct 22 Sun 2006 20:09
Data labels
Excel 2000: The data labels are showing with a white background on a gray
plot area. I have formatted the data label background to the same colour of
- Oct 22 Sun 2006 20:09
Can I automatically extend formulas to added lines in Excel 2002?
When I add new lines to expand a worksheet, existing formulas do not extend
to the new lines. I have the Tools/Options/Edit 'Extend List Formats amp;
- Oct 22 Sun 2006 20:09
Cursor moving slow in excel
Please help. I must have unintentionally changed a setting. In Excel 2003,
when I move from cell to cell holding the top/bottom/left or right arrows
- Oct 22 Sun 2006 20:09
Lookup a value between two numbers
If you have two values that equals a certain value, now let says the
value that you have falls in between these two values, how do you get