How to fix the error message when making changes to a table with multiple tabs selected?

Question

Hello

My spreadsheet has several sheets, each containing a table. I want to modify the formula in a cell (A6, for example) on three of the sheets: I select each sheet using the CTRL key, then type something in cell A6. A pop-up window warns me, "Cannot make changes to a table or XML mapping when multiple sheets are selected." The change only takes effect on sheets 1 and 2, but it's sheet 3 that's failing.

How can I do it?

Answer 1

Good day Sutton, 

Based on your description, it appears that the cell on Sheet 3 is part of an Excel table or contains an XML mapping. Excel doesn't allow changes to tables or XML mapped ranges when multiple worksheets are selected, which is why you see this error message. 

As a workaround, you can make the change on a sheet where it works correctly, such as Sheet 1 or Sheet 2, then copy the updated formula and paste it into the corresponding cell on Sheet 3. 

I completely understand how this limitation in Excel can feel disruptive. It’s not just about aesthetics; these differences can genuinely affect how smoothly you work and navigate your day. 

As a forum user, I hope you understand that I don’t have the ability to modify or escalate product issues directly. However, I strongly recommend submitting your feedback through the Excel · Community. This is the most effective way to ensure your voice reaches the product team and can be considered for future improvements.  

Once you've submitted your feedback, feel free to share the link here in the comments. I’ll be happy to upvote it to help bring more visibility.  

Additionally, as other users have raised similar concerns and may not be aware of where to share their feedback, I hope this response helps clarify the situation. Highlighting this information can make it more visible to others in the community who may be facing the same issue, making it easier for them to find guidance and contribute their feedback as well. 

Thank you again for your time and for raising this important usability concern. 

---

If the answer is helpful, please click "Yes" and kindly upvote it. If you have any extra questions about this answer, please click "Comment".            

Note: Please follow the steps in the forum documentation to enable e-mail notifications if you want to receive the related email notification for this thread.