I would like to refresh using VBA for Excel 2010 a worksheet that is a part of the workbook.
I have one expecific cell that is linked to another worksheet in the same workbook.
I this worksheet I have a pivot table that takes data from the other worksheet.
I would like to refresh the worksheet every 3 seconds automatically.

How can I do that?