Problem Solving:Software
This recalculation only happens
the AutoSave feature are not retained.
are not saved. List boxes and combo
with files created in Excel 97. Contrary
Microsoft has confirmed this to be a
boxes created using the Forms toolbar
to what is stated in the Excel 2000 on
bug in Excel 2000. No fix is currently
may lose their list settings. Conditional
line help, it does not happen with files
available.
formatting that is stored on an XLM
from Excel 95 or earlier versions.
style macro sheet is also not saved.
Note that the file format of Excel
HTML file gets longer each time that
Therefore, you should not use
workbooks is unchanged between ver
it is published
HTML as the default file format for
sion 97 and 2000 so you can safely
Excel workbooks.
move files between versions.
Each time that you publish an Excel
If you want to prevent the slow load
2000 worksheet as a Web page, the size
Error clicking Export To Excel when
ing of files, perhaps because you have
of the HTML file grows by two bytes.
exporting OLAP data
large workbooks that you wish to con
This is because Excel inserts a blank
vert to Excel 2000 format, turn off auto
line just above the tag in the
When you click the Export to Excel
recalculation before loading the files.
HTML file each time you republish the
button on the PivotTable toolbar, you
file. These blank lines can be safely
may receive an error message which
Can't open workbook that contains
deleted if you wish.
says Totals in this PivotTable list do
XLM macros when macro security is
not include data that is hidden by fil
set to high
Some workbook features not re
tering. When you export this Pivot
tained when saving as a Web page
Table list to Excel, the totals in the
If a workbook contains Excel 4.0
Excel PivotTable report will include
(XLM) macros and the security level of
When you open an Excel 2000
the hidden data, and as a result the
Excel 2000 has been set to High, Excel
workbook file that has been saved as a
total values in the Excel report will be
2000 refuses to import the file. An error
Web page, some elements that were
different . You may also receive an
message states This workbook con
present in the original Excel workbook
other message saying The totals in
tains a type of macro (Microsoft Excel
may be lost. This behaviour is by de
your Excel PivotTable do not match
version 4.0 macro) that cannot be dis
sign, says Microsoft.
the totals displayed in your Microsoft
abled or signed. Therefore, this work
Features which are not retained
Office PivotTable list .
book cannot be opened under High
when you save a workbook as a Web
This problem occurs if your Pivot
Security Level .
page include custom views, unused
Table list summarizes data from an
To resolve this problem, you can
number formats, unused styles, data
Online Analytical Processing (OLAP)
add a key to the registry that will allow
consolidation settings, scenarios and
data source. Excel PivotTable reports
Excel to run XLM macros when the
natural language formulas.
do not calculate totals based on OLAP
macro security level is set to High. To
Natural language formulas are con
data. Excel utilizes pre calculated to
do this start by running REGEDIT
verted to standard range references. If
tals that reside on the database server.
then, in the left pane, click the +
your workbook was set to display
As a result, totals in Excel PivotTable
signs to the left of the following items
more than one window, only one win
reports include hidden items.
(in
order):
HKEY_LOCAL_MA
dow is displayed when you open the
To make the behaviour of your
CHINE, Software, Microsoft, Office,
HTML file. All user defined functions
PivotTable list consistent with the be
9.0, Excel. On the Edit menu, point to
appear in the User Defined function
haviour of Excel PivotTable reports,
New, and click Key. Type Security and
category in the Paste Function dialog
enable the Total All Items check box.
then press Enter. On the Edit menu,
box. Shared workbooks are no longer
To do this:
point to New, and click DWORD
shared.
Value. Type XLM, and then press En
Also, the change history is lost
1 Click the title bar of your Pivot
ter. Double click XLM. Type 1 in the
when you save your workbook as a
Table list to select the entire table.
Value box, and then click OK.
Web page and the workbook is no
2 Click the Property Toolbox button
Once you add the XLM key to the
longer shared.
on the PivotTable toolbar.
registry, XLM macros cannot be dis
The Value (Y) axis crosses at cate
3 Click the Totals pane.
abled. When you open a workbook
gory number setting on the scale tab
4 Click to select the Total All Items
that contains XLM macro code, you
of the Format Axis dialog box is not
check box.
will be prompted with a message
saved if the Value (Y) axis crosses a
warning that the macro could contain
maximum category check box is se
Totals missing from PivotTable
viruses, but giving you the option of
lected. The Vary colors by point set
opening the file anyway.
ting in the Format Data Series dialog
When you open a Web page that
box is not saved if the chart contains
contains a Microsoft Office PivotTable
AutoSave settings not retained be
more than one data series. Customized
list, one or more of the data fields may
tween Excel 2000 sessions
page Setup settings for charts that are
be blank. A No Totals heading ap
embedded on a worksheet are not saved.
pears for one or more of the data fields.
When you start Excel 2000, the set
Strikethrough,
Superscript
and
Or, one or more of the data fields in the
tings that you previously specified for
Subscript formatting elements in Styles
PivotTable may not appear until you
File: P1138.2
Update 130 (September 1999) page 10
PC Support Advisor
< Next page >
New! The best sites for quality inkjet printer cartridges and the best sites for cheap inkjet cartridges
Windows Help Desk Home