Name cannot be the same as a built in name что делать

Name cannot be the same as a built in name что делать

Столкнулся с проблемой. Сам порыл, но что-то не понял сути.

Кратко:
1. Есть моя программа у клиента. Через OLE читает из файла Excel.
2. Есть у клиента файл xlsx (у клиента Excel 2007 — т.е. мой OLE пользуется этой версией). Файл создан третьей стороной. Я пока не выяснил, кто создавал (тех. возможности спросить нет).
3. При открытии файла в моей программе появляется диалог:
Name conflict
Name cannot be same as a build-in name.
Old name: _FilterDatabase
New name:
Ok Cancel
4. У себя дома открывал файл на Excel 2003 — тот же диалог выводится.

Что сам нарыл:
1. В инете инфы много. Понял, что это фича Екселя, если не ошибка. Честно. сути не понял. Но вроде как связано с автофильтрацией. Самому создать в GUI Екселя такой файл у меня не вышло.

Вопрос:
1. Сталкивался кто-то с подобным?
2. Что делать? Править писателя файла (третью сторону) или править читателя (мою программу)?

← →
Jeer © ( 2014-01-14 23:55 ) [1]

Конечно — читателя:)

← →
ТимоховД ( 2014-01-15 12:45 ) [2]

> Конечно — читателя:)

Ответ не верный.
Это уже мне понятно.

Тут важнее — было ли у кого такое?

← →
TRWR © ( 2014-04-05 23:43 ) [3]

http://www.sql.ru/forum/543092/excel-2007-konflikt-imen

← →
TRWR © ( 2014-04-05 23:44 ) [4]

http://www.sql.ru/forum/543092/excel-2007-konflikt-imen

← →
ТимоховД ( 2014-04-06 16:27 ) [5]

> TRWR © (05.04.14 23:44) [4]

Большое спасибо! Похоже на решение проблемы. Попробую.
Пропустил, когда сам рыл решение.

← →
ТимоховД ( 2014-04-06 16:27 ) [6]

> TRWR © (05.04.14 23:44) [4]

Большое спасибо! Похоже на решение проблемы. Попробую.
Пропустил, когда сам рыл решение.

Name cannot be the same as a built in name что делать

Argument ‘Topic id’ is null or empty

Сейчас на форуме

© Николай Павлов, Planetaexcel, 2006-2023
info@planetaexcel.ru

Использование любых материалов сайта допускается строго с указанием прямой ссылки на источник, упоминанием названия сайта, имени автора и неизменности исходного текста и иллюстраций.

ООО «Планета Эксел» ИНН 7735603520 ОГРН 1147746834949

ИП Павлов Николай Владимирович ИНН 633015842586 ОГРНИП 310633031600071

How to Resolve a Name Conflict for a Named Range in Excel

When you try to copy two or more sheets from one file to another, a name conflict error could occur if the files both have any of the same range names. You get a warning that the range name already exists, and Excel asks if you wish to rename the range name or use the existing version of that name. For example:

1. Select two or more sheets in the workbook that contain range names that are identical in the destination workbook.
2. Right-click on the sheet tabs and choose Move or Copy.

The name conflict message appears.

Use Existing Versions of Names

Click Yes to use the existing version of the name. This mean that the range name coming in from the copied sheet will be removed and the original name in the destination sheet will be used.

Click Yes to All to use all the existing range names.

Rename Ranges

If you click No, you can give the existing range name from the copied sheet a new name in the current sheet. This is useful if the range name is used in formulas.

1. Click No to rename the range name.

As shown in the picture above, the original named range December from the source sheet is named Dec in the sheet it’s moved or copied to.

Duplicate Range Names

If you select a single sheet to copy or move to a book where some destination names are identical, you don’t receive this warning. Excel copies the sheet with its range names but alter the scope of each name to the sheet instead of the workbook.

Right-click on one sheet to copy to another open workbook and choose Move or Copy.

No warning appears.

However, if you look in the name manager of the destination book, there are two versions of some of the range names. See the picture below. The original names have Workbook as the scope, while the copied names have a scope of just their own sheet (e.g., 3rdQuarter).

Why am I seeing the Name Conflict dialog box in Excel?

If you are seeing the Name Conflict dialog box in Excel, that’s because you are trying to copy one or more worksheets to a workbook that has similar named ranges.

Suppose the worksheet that you’re trying to copy and the destination workbook where you want to copy the worksheet into both have a named range called InterestRates. When you try to move or copy the worksheet, Excel will detect this conflict and display the following message:

The name ‘InterestRates’ already exists. Click Yes to use that version of the name, or click No to rename the version of ‘InterestRates’ you’re moving or copying.

Note: The Name Conflict dialog box will appear for every instance of a conflicting name range. If you are using a subscription version of Excel then the conflict dialog message includes a third option labeled Yes to All which means you won’t see the message appear for additional conflicting name ranges.

Resolution

When you see the above dialog box, you must do one of the following:

Click Yes to continue using the conflicting range name in the destination workbook. What happens when you click Yes? Excel will copy the conflicting name range to the destination workbook. That means you will have two similarly named ranges in your destination workbook.

Warning: If there are formulas that refer to conflicting named ranges in your workbook, then copying those ranges will affect those formulas and cause errors in the workbook. If you are not familiar with the data in the destination workbook, do not click Yes. Instead click No to rename the conflicting range.

Warning: If there are formulas that refer to conflicting named ranges in your workbook, then copying those ranges will affect those formulas and cause errors in the workbook. If you are not familiar with the data in the destination workbook, do not click Yes to All. Instead click No to rename the conflicting ranges one by one.

Click No to rename the conflicting name range. This displays the following dialog box.

1. In the New name section, enter a new name for the range. The new name will not be accepted if it
   • starts with a letter or underscore,
   • is a cell reference, such as A1, A123, or XFD21,
   • has spaces or characters (\, /, *, [, ], :, ?), or
   • has the same name as another range in the workbook that you are copying to.
2. Click OK.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.