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

ID: q127759

The information in this article applies to:

Microsoft Works for Windows, versions 3.0, 3.0a, 3.0b, 4.0, 4.0a, 4.5, 4.5a

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 this to be a problem in the Microsoft products 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 kbinterop
Version : WINDOWS|MACINTOS:3.0,3.0a,3.0b,4.0,4.0a,4.5,4.5a
Platform : WINDOWS|MACINTOS
Issue type : kbbug