Crystal Xcelsius is a dynamic graphing/dashboard application that takes the
underlying excel data (and formulas) and uses it to produce really nice
interactive displays....so I actually have to build the underlying formulas
into excel, which ultimately gets embedded in Xcelsius and provides the
dynamic content.

Usually, all of the suggestions here would work very well, but I'm having to
try to build the excel sheet to ultimately work with Xcelsius....and Xcelsius
support is pretty poor (unless you own their really expensive "enterprise"
product!)

"Dave F" wrote:

Why can;t you use Max's suggestion and paste the values? Do you need to
retain the formulas?
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Max" wrote:

Sad to hear it's not an option, David. Probably you would have earlier ruled
out using an autofilter on the store# col as well? Just a thought.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"David B" wrote:
Max,
Thanks for your reply; again an excellent suggestion. But, Xcelsius is not
able to use "row" functions. I had previously run into this limitation with
another spreadsheet.