Hi...I have tables in 12 sheets (Jan - Dec) and synchronize them into a YTD table which adds the data from each month by formula. Is there any way to insert a row on all the tables, at once so they remain synched? When I select all the worksheets, I cannot insert rows in the tables ( or in fact do any design changes - like rename a column) " Cannot makes changes to a table or XML mapping when multiple sheets are selected" . What I end up doing is selecting each sheet and making the changes.....Appreciate any help
Thanks
Thanks