View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
fruitticher fruitticher is offline
external usenet poster
 
Posts: 11
Default Using named ranges in dynamic charts (excel 2007)

OssicMac,

That's excellent information! Thanks for taking the time.

Yesterday I tried to recreate the spreadsheet, thinking that maybe there was
merely something corrupt in a cell or named range somewhere. But then I spent
all afternoon trying to figure out an error I kept getting about a missing
link to a workbook that never existed. This error only came up after I
created the named range for the labels of my data. No matter the name of the
range, as soon as I created this range and saved/closed the file, upon
reopening I would get the missing link notification. So that got me off track
chasing that down. Never found out what it was though. I had copied a bunch
of cells over and althought I can't find anything I suspect there's something
in a formula somewhere that this new workbook is misinterpreting.

But now I will go back to the original workbook and shorten my range names.

There's always something, isn't there?

Thanks again for all your legwork. Sure does help!

Regards,
fruitticher

"OssieMac" wrote:

Hi again Fruitticher,

I did some testing and found some problems like you described. I think that
I have overcome all of them by shortening the names for the named ranges.

I copied the named ranges you posted and I experienced similar problems
trying to insert them in the formula bar. The first one like you said worked
but the second one would not. On saving, closing and re-opening I had lost
the display of the formula on the formula bar.

I started again with a new worksheet and used shorter names for the named
ranges and it appeared to overcome all the problems.

I then went back to the workbook where the formulas would not display and
re-named the ranges with shorter names in Name Manager. The formulas were not
immediately visible but after saving and re-opening the formulas became
visible. I was then able to insert the new shorter names where previously I
could not.

Also I'm sure that I have seen a message at times something like "the range
is too complex to display" when accessing the ranges by right clicking on the
series and selecting 'Select Data' but I can't replicate that at the moment.

I'll be interested in any further comments that you or anyone else has on
the subject.

Regards,

OssieMac