On 08/09/12 17:20, Larry Evans wrote: > On 08/09/12 14:55, Regina Henschel wrote: >> Hi Larry, >> >> the associated data range goes only to column E not to column F. >> >> Open Insert > Names > Labels and klick on the entry containing >> "[TabelPref...". Look below into the field "data range". In addition >> you see a blew border around the range on the sheet. >> >> Kind regards >> Regina >> > Thanks Regina. > > I did check this to make sure the range reached column F. > I just opened the spreadsheet again and checked again. > My OO shows a data range: > > $Sheet1.$B$19:$F$1048576 > > So the range does go to column F, but what is still puzzling is why > it goes to row 1048576, because I did limit the range to row 35. > I also remember having to reset the row limit to row35 after, > for some mysterious reason OO resets the limit to 1048576. > > Now, despite the range going to the bottom of the spreadsheet. > B37 still shows the #REF! error. > > It sounds like sometimes the range is set correctly, then for some > unknown reason, it gets reset. I've no idea why, but it does sound > like at least a usability bug to me. By that I means that if it's so > hard to get it right or so easy to get it wrong, then it's not very usable. > > Ah!. It was the row range that was being limited to column E. Corrected that and now it works.
Thanks. -Larry --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
