Naming a cell then linking with a certain amount of charachters looses content.

shabbaranks · #1 12-20-2011, 08:24 AM

Here's one for you Excel guru's... If you create a spreadhseet and then name a cell FatherChristmas(or what ever you like) and then link that cell within document properties - custom. If you go over a certain amount of characters the cell looses the content youve put in and replaces it with the cell name.

Any ideas why this is?

Thanks

macropod · #2 12-27-2011, 01:06 AM

Hi shabbaranks,

I suspect this is by design - the same happens in Excel 2003 & Excel 2010. Although I haven't tested it, you'll probably find it occurs when you hit, say, 256 or 1024 characters.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
using a cell content as a string with COUNTIF	geoffm	Excel	1	08-16-2011 11:31 AM
How can I delete the content of a cell in column if the cell value is more than 1000?	Learner7	Excel	2	06-27-2011 05:44 AM
Linking text from an embedded sreadsheet cell	spheon	Word	2	05-26-2011 01:03 PM
Cell content splits	Mahen	Excel	2	05-15-2011 01:53 AM
Linking page numbers and Table of Content	tworthen	Word Tables	1	08-04-2009 05:14 PM