Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range name problem for DA
SORRY IF THIS IS A 2ND POSTING BY ACCIDENT BUT, IF SO,
PLEASE READ THIS ONE NOT THE PRIOR A file I have contained one worksheet that was a cosmetically pretty echo of another of my worksheets that was full of actual inputs, many of which I range-named. I sent this file to a colleague who wanted me to make the former worksheet even prettier for his client. He sent the new file back to me but, since I was continuing with other changes, while he did it, I needed to simply capture all his cosmetic changes in that one worksheet, which had only results, no cells that drove anything else. So, I deleted my worksheet and copied his in. I don't recall getting asked any questions about range names when I did, but I may have. I then deleted his file from my computer. In any event, whenever I create a cell with one of these "smart labels", e..g, "with a value of "&text(v2,"0%")"&"...", where v2 is one of the range-named input cells, when I try to hit enter, it brings up a dialog box called "update values: his filename.xls", looking for me to choose a filename with his filename being some other filename on his system (his computer and mine are not linked, could it be sitting in my temp files?). Whatever I did next, to deal with that EXCEL reaction, that smart cell then turned to garbage. If I then go to insert/name/define, instead of the range names I created within my file, I see the same names but referenced from his modified copy of the file - to be clear he did not change any range names. I proceeded to delete them all and then all is fine.... until I create another one of these smart cells. Then, the problem starts all over again. Bottom line, it seems that his range names are overtaking mine and keep finding their way back into my file. Why is this happening and how can I expunge his range names from my computer. Thanks! Dean |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range name problem for DA
Just a little update: The range name references I see are to his other
file, not the one he sent me even, the same file it asks me to update values of. And it doesn't take a complex formula to cause a problem. If I just set a new cell equal to one of my range named cells, the problem occurs. Alternatively, I would consider removing all the range names, but if other cells were set equal to them after they were range named, I think that will turn them to garbage (like deleting the cell it is looking at). Is there a way to delete all range names in a file without compromising the relationships within the file? I could live without the range names, if need be. There is no asking for updates when I open the file and edit links is hushed, so this is strictly a phantom range name problem. I saw a great link on this but, since I can't get to the file it wants to see, the solutions proposed don't work. http://www.windowsdevcenter.com/pub/...05/index1.html Thanks again! Dean "Dean" wrote in message ... SORRY IF THIS IS A 2ND POSTING BY ACCIDENT BUT, IF SO, PLEASE READ THIS ONE NOT THE PRIOR A file I have contained one worksheet that was a cosmetically pretty echo of another of my worksheets that was full of actual inputs, many of which I range-named. I sent this file to a colleague who wanted me to make the former worksheet even prettier for his client. He sent the new file back to me but, since I was continuing with other changes, while he did it, I needed to simply capture all his cosmetic changes in that one worksheet, which had only results, no cells that drove anything else. So, I deleted my worksheet and copied his in. I don't recall getting asked any questions about range names when I did, but I may have. I then deleted his file from my computer. In any event, whenever I create a cell with one of these "smart labels", e..g, "with a value of "&text(v2,"0%")"&"...", where v2 is one of the range-named input cells, when I try to hit enter, it brings up a dialog box called "update values: his filename.xls", looking for me to choose a filename with his filename being some other filename on his system (his computer and mine are not linked, could it be sitting in my temp files?). Whatever I did next, to deal with that EXCEL reaction, that smart cell then turned to garbage. If I then go to insert/name/define, instead of the range names I created within my file, I see the same names but referenced from his modified copy of the file - to be clear he did not change any range names. I proceeded to delete them all and then all is fine.... until I create another one of these smart cells. Then, the problem starts all over again. Bottom line, it seems that his range names are overtaking mine and keep finding their way back into my file. Why is this happening and how can I expunge his range names from my computer. Thanks! Dean |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range name problem for DA
OK, I finally found a solution so no need to reply:
"Dean" wrote in message ... Just a little update: The range name references I see are to his other file, not the one he sent me even, the same file it asks me to update values of. And it doesn't take a complex formula to cause a problem. If I just set a new cell equal to one of my range named cells, the problem occurs. Alternatively, I would consider removing all the range names, but if other cells were set equal to them after they were range named, I think that will turn them to garbage (like deleting the cell it is looking at). Is there a way to delete all range names in a file without compromising the relationships within the file? I could live without the range names, if need be. There is no asking for updates when I open the file and edit links is hushed, so this is strictly a phantom range name problem. I saw a great link on this but, since I can't get to the file it wants to see, the solutions proposed don't work. http://www.windowsdevcenter.com/pub/...05/index1.html Thanks again! Dean "Dean" wrote in message ... SORRY IF THIS IS A 2ND POSTING BY ACCIDENT BUT, IF SO, PLEASE READ THIS ONE NOT THE PRIOR A file I have contained one worksheet that was a cosmetically pretty echo of another of my worksheets that was full of actual inputs, many of which I range-named. I sent this file to a colleague who wanted me to make the former worksheet even prettier for his client. He sent the new file back to me but, since I was continuing with other changes, while he did it, I needed to simply capture all his cosmetic changes in that one worksheet, which had only results, no cells that drove anything else. So, I deleted my worksheet and copied his in. I don't recall getting asked any questions about range names when I did, but I may have. I then deleted his file from my computer. In any event, whenever I create a cell with one of these "smart labels", e..g, "with a value of "&text(v2,"0%")"&"...", where v2 is one of the range-named input cells, when I try to hit enter, it brings up a dialog box called "update values: his filename.xls", looking for me to choose a filename with his filename being some other filename on his system (his computer and mine are not linked, could it be sitting in my temp files?). Whatever I did next, to deal with that EXCEL reaction, that smart cell then turned to garbage. If I then go to insert/name/define, instead of the range names I created within my file, I see the same names but referenced from his modified copy of the file - to be clear he did not change any range names. I proceeded to delete them all and then all is fine.... until I create another one of these smart cells. Then, the problem starts all over again. Bottom line, it seems that his range names are overtaking mine and keep finding their way back into my file. Why is this happening and how can I expunge his range names from my computer. Thanks! Dean |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
3D range problem | Excel Worksheet Functions | |||
Range problem | Excel Programming | |||
Range problem | Excel Programming | |||
Range problem | Excel Programming | |||
Range problem | Excel Programming |