excel table help!
excel table help!
i have linked queries on a spreadsheet to the same database.
on one "table" that i pull in, it lets me subtotal.
on another "table i pull in, it doesn't let me subtotal.
i have googled this issue and it keeps saying that you must convert to a range in order for it to be able to subtotal. however this doesn't seem like it's the case with the first table.
they are both coming from select queries and both queries are written very similar.
i need to be able to subtotal the 2nd table! any ideas???
on one "table" that i pull in, it lets me subtotal.
on another "table i pull in, it doesn't let me subtotal.
i have googled this issue and it keeps saying that you must convert to a range in order for it to be able to subtotal. however this doesn't seem like it's the case with the first table.
they are both coming from select queries and both queries are written very similar.
i need to be able to subtotal the 2nd table! any ideas???
This discussion has been closed.
Replies
Allan