I have a Worksheet that has data entered into a cell using a handheld scanner. After it scans, it moves down one cell so the next item can be scanned. For some reason after the last item is scanned it doesn't refresh the pivot table. I use this as a method to verify items needed for an order. It keeps up with how many I have scanned using a Pivot Table. I didn't have any issues until I upgraded to Office 365. Does anyone have any ideas? It will move down 1 to next cell, but Pivot Table doesn't always refresh. I have tried turning screen updating off while it does this.

Please Login or Register  to view this content.