Microsoft KB Archive/127759

Knowledge Base

Works Error: "Invalid Range Names" When Saving as Excel File

Article ID: 127759

Article Last Modified on 11/15/2004

---

APPLIES TO

• Microsoft Works 3.0 Standard Edition
• Microsoft Works 3.0a
• Microsoft Works 3.0b
• Microsoft Works 4.5 Standard Edition
• Microsoft Works 4.5a
• Microsoft Works 4.0 Standard Edition
• Microsoft Works 4.0a

---

This article was previously published under Q127759

SYMPTOMS

When you save a Works for Windows spreadsheet in the Microsoft Excel format with a print area defined, you receive the following error message.

Works 4.0, 4.0a, 4.5, and 4.5a

Invalid Range Names.

Make sure your range names begin with a letter, an underscore (_), or a backslash (\), and contain only letters or numbers.

Works 3.x

Invalid Range Names.

You have chosen an invalid range name for Excel. Make sure your range names begin with a letter, an underscore (_), or a backslash (\), and contain only letters and numbers.

Clicking OK converts the spreadsheet; however, the Print Area range name doesn't convert when the spreadsheet is brought into Excel.

CAUSE

Setting a Print Area in a Works for Windows spreadsheet generates a Print Area range name that contains an invalid character for an Excel range name.

NOTE: This character is the space between "Print" and "Area."

STATUS

The Print Area will not be converted when you save a Works spreadsheet as an Excel file type or if you save an Excel spreadsheet as a Works file.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: 3.00 3.00a 3.00b 4.00 4.00a 4.50 4.50a w_works printspace conversions

Keywords: kberrmsg kbbug kbinterop kbpending KB127759

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.