Purchase Order Increment

Hi guys,

Attached is a purchase order excel file. What I want to do is get the purchase order field to increment by one every time someone opens the master template. They will then save the file as a normal excel worksheet.
However I can’t get it to increment each time it opens. I am starting to tear my hair out.

Any help much appreciated!!

Knightrider99