List vs. Toggle Total Row
I have defined a list in Excel 2003, entered sample data in Row 1, and
selected "Toggle Total Row" to display sums/counts in the last row. I want to use these numbers as a reference for other formulas in the workbook. The problem I'm experiencing is that sometimes, after I close and reopen the workbook, the total row is appearing outside the defined list boundary, in the first row underneath the defined boundary. I have done nothing except save and close the file. If I select "Toggle Total Row" again, a new total row appears within the list boundary...and the rogue total row still remains outside the list! I am approaching a deadline at work, so any help anyone could provide would be greatly appreciated. I'm about ready to convert the list to a range just to meet deadline, but I really don't want to have to do that unless as a last resort. Thanks in advance for any help you can provide! |
All times are GMT +1. The time now is 10:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com