Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've tried to append a plain table after a pivot table but it never shows up. I've prepending the table but it never pulls in the data. I was able to add a header to the page. Is this not possible ?
The top line is a plain table which never pulls in the rows
Weird - so the solution was to have at least 2 blank rows between the objects but this will not work if the table object is below the pivot table. I tried 5 blank rows but only the pivot table shows up.
For plain text (e.g. header) only one blank row is necessary. It may even work directly above the pivot table with no blank rows.
I don't understand what is your problem, all what i guess is that some data is not coming through, but without more details it is like searching a needle in haystack.
I would start with giving us following information:
cheers
Lech
Hi,
Did you removed the Expand Range check for the table that is not pulling the rows?
Best Regards,
Ruggero
Weird - so the solution was to have at least 2 blank rows between the objects but this will not work if the table object is below the pivot table. I tried 5 blank rows but only the pivot table shows up.
For plain text (e.g. header) only one blank row is necessary. It may even work directly above the pivot table with no blank rows.
Thanks but tried that. Table does not show up. Have you had success combining tables and pivot tables on the same sheet?