Mac Works: Cell Notes Disappear When Using Headers or Footers
  
PSS ID Number: Q129768
Article last modified on 10-22-1998
 
4.0 4.0a 4.0b
 
MACINTOSH
 

======================================================================
----------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Works for the Macintosh, versions 4.0, 4.0a, 4.0b
----------------------------------------------------------------------
 
SYMPTOMS
========
 
When you try to print or use print preview in a Spreadsheet document that
contains a header and/or footer, cell notes may not print or be visible in
print preview.
 
This also may occur if the header and/or footer is turned on, even if the
document contains no header and/or footer. For example, if you open the
header and/or footer area and do not type anything, Works still doesn't
print the cell notes.
 
WORKAROUND
==========
 
Try one of the following workarounds.
 
Method 1
--------
 
To print cell notes, do the following:
 
1. Open the Spreadsheet that will not print cell notes.
 
2. Select the spreadsheet by pressing COMMAND+A.
 
3. On the Edit menu, click Copy.
 
4. Open a new Spreadsheet.
 
5. On the Edit menu, click Paste.
 
6. On the File menu, click Page Setup and make sure the Print Cell
   Notes box is checked.
 
7. To print the cell notes, print this spreadsheet by clicking Print on
   the File menu.
 
Avoid using the header and footer if you want to continue editing this
spreadsheet and retain the ability to print cell notes.
 
Method 2
--------
 
The following steps allow you to print the cell notes.
 
1. Open the Spreadsheet containing the cell notes. From the File menu,
   choose Save.
 
2. From the File menu, choose Save As.
 
3. From the File Format section, select Multiplan SYLK.
 
4. In the Save Document As section, give the document a different name.
 
5. Choose Save.
 
6. To open this SYLK formatted spreadsheet:
 
    a. In the Open Document dialog box, click on the spreadsheet icon
       once. From the File Format menu, choose Multiplan SYLK .
 
    b. From the file list, select your second document. Choose Open.
 
7. From the File menu, choose Page Setup. Choose Document.
 
8. Select the Print Cell Notes check box.
 
9. From the File menu, choose Print Preview. The problem should be
   corrected.
 
MORE INFORMATION
================
 
You may also lose cell notes when a Works 3.0 document containing headers
and footers is converted to Works 4.0.
 
Microsoft has confirmed this to be a problem in Works versions 4.0, 4.0a,
and 4.0b. We are researching this problem and will post new information
here in the Microsoft Knowledge Base as it becomes available.
 
Additional query words: 4.00 4.00a 4.00b mac m_works cellnotes cell-
notes blank gone missing blanks blanked note
======================================================================
Version           : 4.0 4.0a 4.0b
Platform          : MACINTOSH
Issue type        : kbprb
=============================================================================
Copyright Microsoft Corporation 1998.