Deleting data sheets, Deleting the query log, Saving and exiting the excel client – HP 3PAR StoreServ 7000 Storage User Manual
Page 61
Deleting Data Sheets
Data sheets remain until you manually delete them. Manually deleting a data sheet causes any
embedded charts associated with that data sheet to disappear as well.
To delete a data sheet:
1.
At the bottom of the Microsoft Excel window, click a data sheet tab to enable the sheet to be
deleted.
2.
Point to the name of the data sheet tab and then right-click.
3.
On the shortcut menu that appears, click Delete.
4.
In the confirmation dialog that appears, click OK.
The data sheet is deleted. Any embedded charts associated with that data sheet disappear
as well.
Deleting the Query Log
You can also delete the query log, which is by default a hidden sheet, by making it visible and
then using the method described above to delete it.
To delete the query log:
1.
Make the Query Log tab visible by following the instructions in
2.
At the bottom of the Microsoft Excel window, point to the Query Log tab and then right-click.
3.
On the shortcut menu that appears, click Delete.
4.
In the confirmation dialog that appears, click OK.
The query log is deleted. The next time that you initiate a new query using the Excel workbook,
a new hidden query log sheet is created.
Saving and Exiting the Excel Client
To exit the HP 3PAR System Reporter Excel client workbook, on the File menu, click Close.
Upon exiting, Microsoft Excel will prompt you to save changes. If you have added customized
charts and/or data sheets, as described in
“Working with Excel Charts” (page 98)
, you may want
to save your changes when prompted. However, it is not necessary to save changes and in most
cases it is not desirable to do so. Saving the Excel workbook does not save the Web server
information and saved workbooks do not automatically update embedded charts or data sheets
when they are reopened.
When opening a previously saved Excel worksheet, you may receive a security alert indicating
that macros and data connection have been disabled (
).
Deleting Excel Sheets
61