Subtotals Nightmare in Excel 2003
 

My company just upgraded to Office 2003 and previously we were using Office
2000. I worked with large Excel Spreadsheets and I'm used to creating and
Nesting Subtotals in MS Excel.

I'm working on my Excel 2003 file and I'm trying to Nest up to 3 Subtotals
except I noticed that the Subtotals are not aligning right. The Third
Subtotal is below the 2nd Subtotal when in Excel 2000 the Third Subtotal
would be above the Second Subtotal.

Can someone please clarify this mystery for me?

Thanks,

Subtotals Nightmare in Excel 2003
 

would help if you post the formula you use.....


"Marilyn" wrote:

My company just upgraded to Office 2003 and previously we were using Office
2000. I worked with large Excel Spreadsheets and I'm used to creating and
Nesting Subtotals in MS Excel.

I'm working on my Excel 2003 file and I'm trying to Nest up to 3 Subtotals
except I noticed that the Subtotals are not aligning right. The Third
Subtotal is below the 2nd Subtotal when in Excel 2000 the Third Subtotal
would be above the Second Subtotal.

Can someone please clarify this mystery for me?

Thanks,

Subtotals Nightmare in Excel 2003
 

Probably you might have come across a known issue with Excel 2003. Check
Knowledge Base article 831824 (http://support.microsoft.com/kb/831824).

Hope this helps,
Arun



"Marilyn" wrote in message
...
My company just upgraded to Office 2003 and previously we were using
Office
2000. I worked with large Excel Spreadsheets and I'm used to creating and
Nesting Subtotals in MS Excel.

I'm working on my Excel 2003 file and I'm trying to Nest up to 3 Subtotals
except I noticed that the Subtotals are not aligning right. The Third
Subtotal is below the 2nd Subtotal when in Excel 2000 the Third Subtotal
would be above the Second Subtotal.

Can someone please clarify this mystery for me?

Thanks,

Subtotals Nightmare in Excel 2003
 

I'm not using a formula i'm using the Subtotal feature in Excel. Data,
Subtotal

"rdwj" wrote:

would help if you post the formula you use.....


"Marilyn" wrote:

My company just upgraded to Office 2003 and previously we were using Office
2000. I worked with large Excel Spreadsheets and I'm used to creating and
Nesting Subtotals in MS Excel.

I'm working on my Excel 2003 file and I'm trying to Nest up to 3 Subtotals
except I noticed that the Subtotals are not aligning right. The Third
Subtotal is below the 2nd Subtotal when in Excel 2000 the Third Subtotal
would be above the Second Subtotal.

Can someone please clarify this mystery for me?

Thanks,

Subtotals Nightmare in Excel 2003
 

Thank you AK..... This is exactly what is going on with me.

"AK" wrote:

Probably you might have come across a known issue with Excel 2003. Check
Knowledge Base article 831824 (http://support.microsoft.com/kb/831824).

Hope this helps,
Arun



"Marilyn" wrote in message
...
My company just upgraded to Office 2003 and previously we were using
Office
2000. I worked with large Excel Spreadsheets and I'm used to creating and
Nesting Subtotals in MS Excel.

I'm working on my Excel 2003 file and I'm trying to Nest up to 3 Subtotals
except I noticed that the Subtotals are not aligning right. The Third
Subtotal is below the 2nd Subtotal when in Excel 2000 the Third Subtotal
would be above the Second Subtotal.

Can someone please clarify this mystery for me?

Thanks,