I have a total row across the bottom that sums numbers for each week column. If I filter a column, I loose the total row. Is there a way to keep this total row while I filter different columns?
The problem occurs if you try to share the workbook after you have created your tables so you should create a new blank document and start with sharing it and then proceed creating your tables or simply copy-paste them from your old document and it will work.
Hi Dustin, good to see you again!
When you appy a AutoFilter, XL usually guess as to what range you want to apply the filter. In your example workbook, it included the Total row, which is why it's getting filtered out. To correct:
Turn off AutoFilter.
Select range B3:AK306 (excludes Total Row).
Turn on AutoFilter.
You should now be able to filter w/o losing the Totals.
bobhc: Thank you for the input, but I need the workbook to be shared.
Luke M: Hi Luke! Thank you for repyling to my thread. I tried it several times without any luck. I continue to loose the total row. As bobhc commented, if I take it out of share mode, I can get it to work. Any more ideas or mind amending the attach file that I shared? Thank you again.
No,No,No what I am saying is create the shared workbook FIRST and then enter data, formulas, function, TABLES, CF and all the rest or as I pointed out, create the SHARED workbook and then just copy paste your sheets into it. .
bobhc: no no no - , kidding. Thank you for your patience and clarification. This did work, thank you.
Luke M: Your file worked perfect. I then went back to your instructions to try modifying the file again, and this worked too. Hence, I have no idea what I was doing yesterday. Thanks Luke.
Narayan: I tried this scenrio, and it worked as well. Thank you for the input.