Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem - hidden cell names in worksheet
i all
I am having a strange issue with my excell file since a while. This is the second year I am using it without problem. I start a workday with a new sheet so every morning I just copy (Edit/Move or Copy Sheet) the latest sheet, rename it and use it. All of a suddent when I perform this operation I have a prompt that says "a formula or sheet you want to move or copy contains the name 'aaa', which exists in the destination worksheet. Do you want to use this version of the name?" I would hit yes to proceed, then I would get over 50 other prompts with different names, and finally a new sheet. My file contains a macro who basically inserts the current time in the active cell. Apart from that there is no named cell. Has anyone ever experienced such problem? How was it resolved? Thanks you very much for your help. -- Bigger |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem - hidden cell names in worksheet
Hi
Probably you accidentelly named some range - it may happen easily (you activated Name field (the one where usually active cell address is displayed, typed 'aaa', and hit Enter) In Excel 2000 or like, select InsertNameDefine (in Excel2007 it is in different location, search help for 'Named Range'. You see a list of defined names - delete all names 'aaa' (you see probably one - for active sheet. When you delete it, the next one is displayed, etc. delete until none is left. Arvi Laanemets "Bigger" wrote in message ... i all I am having a strange issue with my excell file since a while. This is the second year I am using it without problem. I start a workday with a new sheet so every morning I just copy (Edit/Move or Copy Sheet) the latest sheet, rename it and use it. All of a suddent when I perform this operation I have a prompt that says "a formula or sheet you want to move or copy contains the name 'aaa', which exists in the destination worksheet. Do you want to use this version of the name?" I would hit yes to proceed, then I would get over 50 other prompts with different names, and finally a new sheet. My file contains a macro who basically inserts the current time in the active cell. Apart from that there is no named cell. Has anyone ever experienced such problem? How was it resolved? Thanks you very much for your help. -- Bigger |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem - hidden cell names in worksheet
Arvi,
Thank you fr your response and sorry for not having replied soonner. I had travelled for the ween-end. I followed tthe path InsertNameDefine, the Define name box is empty. no name shows up. I am using MS Office Excel 2003 and Windows XP Professional Don't know what to do. -- Bigger Douala, Cameroun "Arvi Laanemets" wrote: Hi Probably you accidentelly named some range - it may happen easily (you activated Name field (the one where usually active cell address is displayed, typed 'aaa', and hit Enter) In Excel 2000 or like, select InsertNameDefine (in Excel2007 it is in different location, search help for 'Named Range'. You see a list of defined names - delete all names 'aaa' (you see probably one - for active sheet. When you delete it, the next one is displayed, etc. delete until none is left. Arvi Laanemets "Bigger" wrote in message ... i all I am having a strange issue with my excell file since a while. This is the second year I am using it without problem. I start a workday with a new sheet so every morning I just copy (Edit/Move or Copy Sheet) the latest sheet, rename it and use it. All of a suddent when I perform this operation I have a prompt that says "a formula or sheet you want to move or copy contains the name 'aaa', which exists in the destination worksheet. Do you want to use this version of the name?" I would hit yes to proceed, then I would get over 50 other prompts with different names, and finally a new sheet. My file contains a macro who basically inserts the current time in the active cell. Apart from that there is no named cell. Has anyone ever experienced such problem? How was it resolved? Thanks you very much for your help. -- Bigger . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da | Excel Discussion (Misc queries) | |||
Problem with worksheet names containing charts | Excel Discussion (Misc queries) | |||
How do I detect hidden worksheets or hidden data on a worksheet? | Excel Discussion (Misc queries) | |||
How to find hidden names on an Excel worksheet ? | Excel Worksheet Functions | |||
Worksheet copy problem - local names | Excel Discussion (Misc queries) |