fncuis wrote:
Woah...

Ok, option 1 I think I can handle... basically, have a second
worksheet or second workbook for the presentation side. Do a bunch
of linked columns/cells and impose the formatting there? As I
refresh the (source) workbook/sheet it automatically carries over.

More work, but It's in my latitude.

Yes, that's what I was suggesting.

Option 3: We use a business software called FACTS. It's not the
friendliest program around but allows for ODBC, as I am using it right
now. Correct me if I am wrong, but what you are saying is: during
the database query, "view data or edit in ms query"? and give it my
SQL commands there?

Yeah, since FACTS allows for SQL queries, you could just edit the query in
MS Query. SQL can be a difficult language to do text formatting and such,
and it's not the best place for presentation logic, but you may be able to
find a workable solution and avoid the separate worksheet.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]