Note that the apostrophes enclose the workbook and worksheet names. The apostrophes are necessary because the space between 1994 and Figures could be interpreted as a divider between items.
If the name of your worksheet contains an apostrophe, and you want to reference a range on this worksheet, you must add another apostrophe to the reference in order to distinguish the apostrophe in the name from apostrophes that enclose a name. For example, to reference cell A1 on the worksheet "1995's Forecasts" in BOOK1.XLS, use the following formula:
If your worksheet name contains an apostrophe, you may be unable to complete certain operations that use the worksheet name. Examples of these operations are shown below.
In general, avoid using apostrophes in your worksheet names.
Print Area not Retained in a View
If the name of your worksheet contains an apostrophe, and you create a view, using View Manager, the print area that is set for the view may not be retained.
Cannot Delete Locally Defined Names
If the name of your worksheet contains an apostrophe, you cannot delete locally defined names on the worksheet. when you select the name in the Define Name dialog box and choose Delete, you receive the error message "That name is not valid" appears and the name is not deleted.
To delete a locally defined name, such as '1995''s Forecasts'!Print_Area, you must rename the worksheet with a name that does not contain any apostrophes.
Cannot Create Locally Defined Names
If you try to create a local name on a worksheet when the worksheet name contains an apostrophe, you receive the following error message
To create a local name on a worksheet when the worksheet name contains an apostrophe, do the following:
- Rename the worksheet with a name that does not contain an apostrophe.
- Create the local names.
Cannot Return Data from Microsoft QueryIf you use the Get External Data command, and you return query data from Microsoft Query to a worksheet name contains an apostrophe (or a space), the data is instead returned to the worksheet that was active when you chose the Get External Data command.
To avoid this behavior, do either of the following:
- Activate the worksheet with the name that contains the apostrophe (or space) before you click the Get External Data command.
- Rename the worksheet to a name that does not contain an apostrophe or a space.
Artikel-id: 107468 - Laatst bijgewerkt: 15 aug. 2003 - Revisie: 1