Microsoft KB Archive/127759

= 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.