Microsoft 365 and Office | Excel | For education | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
As far as I know, yes they have to be on the same sheet.
Data table column and Row Input Sheet
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 13%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Soorya K
0
Reputation points
For data table the Row and column input cells should they be in the same sheet where by data table is ? Because when i link the Row and column input cells to a different sheet where the data sheet is not there it shows error or gives in correct results.. Is this an excel condition or is there something wrong iam doing
Microsoft 365 and Office | Excel | For education | Windows
2 answers
Sort by: Most helpful
-
Deleted
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 79%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Rory Archibald 19,055 Reputation points Volunteer Moderator2026-09-06T12:10:10.09+00:00