I have two probably easy questions :)

The first is - what is wrong with this syntax:
<Worksheet ss:Name="[substring('{Metadata/WorksheetName}_Hist',1,31)]">

This is a stylesheet for excel - I want to account for names that could go beyond the max length of 31.

This is the message I get:
XML ERROR in Workbook Setting
REASON: Bad Value
FILE: C:\DOCUME~1\bgunion\LOCALS~1\Temp\17.tmp
GROUP: Workbook
TAG: Worksheet
ATTRIB: Name
VALUE: [substring('Active_insAll_$$_Hist',1,31)]

The second question has to do with a documentation sheet. The sql code must be documented in the workbook. The code has indents and spaces like:

Update tblTriangle_Dollar
    SET Loantotal = a.loans
    FROM (
    SELECT Year(dateContract) Year, datepart(q,datecontract) MQ,
        sum(amtloan) Loans
        FROM loantable
        WHERE dateofdata = 'Sep 30 2004 12:00AM' ....

I can retrieve this code from the data and get it in to an xml file (with spaces) but when I open it in excel i get:

Update tblTriangle_Dollar SET Loantotal = a.loans
FROM (SELECT Year(dateContract) Year, datepart(q,datecontract) MQ,sum(amtloan) Loans FROM smolinski.tblMasterMonthlyData20040930 WHERE dateofdata = 'Sep 30 2004 12:00AM'

Without word-wrap it is one long string. I would like to keep the indents.
Currently the code is one cell (e.g. <code>my code<code/>) - In other word each line is not separate out. It is formatted the way i want it in text form - it just doesn't translate to excel.

Thanks!