I have also experienced this error and what I did to get rid of it was just do the cell range instead of "input table". Doing it this way gets rid of a couple options in ArcGIS for Office but I didn't know those options for what I was doing. I also found that when I cut the table and pasted it again in the same worksheet, that worked as well. No idea WHY this error comes up but that was my "hacky" way of getting it work hah.
... View more