Hi All,
I have moved onto Excel 2010 and found that the Custom List limit is now around 1900 Characters (One list cannot be longer than this number). Which means that the Slicers I use, in combination with Custom Lists that are 4000+ Characters long, no longer work.
I cannot find a fix for this, so before writing VBA etc. I wanted to get confirmation from experts that going down the VBA route is the right one.
I have moved onto Excel 2010 and found that the Custom List limit is now around 1900 Characters (One list cannot be longer than this number). Which means that the Slicers I use, in combination with Custom Lists that are 4000+ Characters long, no longer work.
I cannot find a fix for this, so before writing VBA etc. I wanted to get confirmation from experts that going down the VBA route is the right one.
