Product :
MS Excel 97
Question : In Microsoft Excel, if you open a workbook that has a file
size equal to or greater than
the free space on a disk, and you then save the workbook, you may receive
the
error message " Disk is Full " or " Document not saved."
For example, if you open
a 710-kilobyte (KB) workbook on a 1.44-megabyte (MB) disk, and you then change
and save the workbook, you will receive the error messages.
Answer : To avoid this error message, copy the file
to your hard disk drive before you work with
it. After you make modifications, save the file to the hard disk and then
copy it back
onto the floppy disk.
----------------------------------------------------------------
Question: When you save a file in Microsoft Excel, you
may receive one of the following error messa
Questionges: " Invalid file format"
Answer: To maintain the links between the open
document and the temporary files and to avoid
this problem, do not disconnect from the network or remove the floppy disk
from
which the file was opened.If an error occurs when you save a workbook file,
copy
or drag the sheet(s) to a new workbook (to create a new .TMP file in the TEMP
directory) and save the new document.
----------------------------------------------------------------
Question: In Microsoft Excel 97, when you print or view a worksheet
in print preview, the first row
of each printed page after the first page may contain text from another location
in
the worksheet.
Answer: To work around this problem, move the text in the first row
after the print titles range away
from the top of the cells. To do this, follow these steps: 1. Select the first
row after
the print titles range. For example, if the print titles are rows 1 - 3, select
row 4. 2.
On the Format menu, click Cells. 3. Click the Alignment tab. 4. In the Vertical
list box,
click Bottom. Then, click OK. 5. On the Format menu, point to Row, and then
click
Height. 6. In the Row Height box, increase the value by 0.75. For example,
if the
box contains the value 12.75, increase it to 13.50. 7. Then, click OK. After
you complete
these steps, print the worksheet or view it in print preview.
news