Mike wrote:

Well. The file location is in a network, with limited access (for me) so that
doesnt help much.

Your best bet then is to have the workbook remain static and load and
save a tiny file over the network that contains only the dynamically
changing data. The workbook then loads and increments the counter file
when it loads (possibly with a lock mechanism to prevent two concurrent
users getting the same tag ID).

Regards,
Martin Brown