"jeffm70" wrote:
don't know if one can upload a sheet here.. but would
be glad to do sov so you could see the issue??

Yes, we need to see the Excel file, unless you want to take the time to
explain the situation better. (Specific formulas, cell references, etc.)

You can upload an example Excel file (devoid of any private data) that
demonstrates the problem to a file-sharing website and post the "shared",
"public" or "view-only" link (aka URL; http://...) in a response here. The
following is a list of some free file-sharing websites; or use your own.

Box.Net: http://www.box.net/files
Windows Live Skydrive: http://skydrive.live.com
MediaFi http://www.mediafire.com
FileFactory: http://www.filefactory.com
FileSavr: http://www.filesavr.com
RapidSha http://www.rapidshare.com