Before you copy the cells you plan to paste as a linked image, zoom in on your Excel worksheet so that the dataset fills the whole screen.

To take a snapshot of a range not formatted as an Excel table using the Linked Picture tool, select the data, press Ctrl+C to copy it, and click "Linked Picture" in the Paste drop-down menu.