Can you give an answer on 2010 excel I update fileon my workstation but another station has read only file open but does not refresh. Can you help.

the OPs post is not clear
are you moving files from one PC to another?
or 1 pc upgraded from 8 to 10.?
are both PCs with office 2016
did you copy files to say USB and move to 2nd pc.
what is the full story, so answers are 10x more easy to answer.
but use there are tools to fix windows office files of all kinds
for sure if you as a microsoft.com ,it is there product, not ours.

the file being locked smacks of not begin saved correctly
or the creating system is corrupted.
why not go back to the PC with w8 see if it can open it.
so you'd know its ok. first.
I use office 2007 and to make it not mess up on w10
I had to do all OFFICE updates, to it, first. then it worked, ok.
in fact it had hyperlink bugs.
tell what you did or are doing so we can help.

Use Excel Repair Toolbox is efficient corrupt XLSX file repair software, suitable for all data recovery activities, applied to Microsoft Excel documents.

For more: https://www.xlsxrepairtoolbox.com/

office.microsoft.com/.../excel-help/excel-help-and-how-to-FX10181405..

Here are the steps on how you can make it a read/write file:

1. Make sure that the file is not open in Excel.
2. On the Windows Start menu, point to Programs, point to Accessories, and then click Windows Explorer.
3. In the Exploring window, open the drive or folder that contains the file.
4. Click the file name.
5. On the File menu, click Properties.
6. Click the General tab.
7. Clear the Read-only check box.

Hope this helps!

Use in-build "open and repair"utility of MS excel to repair damaged .xlsx files. Follow thesesteps to it

1. On the File menu, click Open.
   

2. In the Open dialog box, select the file you want to open, and click the arrow next to the Open button.
   

3. Click Open and Repair, and then choose which method you want to use to recover your workbook.
   

Most probably your problem may get fixsuppose due to any reason it can't fix your problem then use thirdparty excel repair softwarehttp://www.stellarinfo.com/excel-recovery.htm

When you purchased your MS Windows XP professional this does not include Microsoft Office 2010.

Microsoft Office 2010. includes, MS Word, MS Excel 2010 etc..

This is a seperate software that you need to purchase in order for you to open excel files.

let me give you an alternative software that you can download for FREE

OPENOFFICE << CLICK

Click Download Now

check the connection of your LAN, or the configuration

Shouldn't be a date issue... did you open the file the way you normally do ?
Something has changed here... bad shut down with this file opened... maybe.
Open Excel and pull down the File Menu and see if there are more than copy or version of your spreadsheet. Look at all...
File could have corrupted the Font or could be a Virus. Try just changing the font in one cell.
If this is your only copy of the file... make a copy to see if it works on another machine... that will isolate the problem... it may just be corrupt... the fix is Excel healing it on it's own when it opens.

There is a get external data function that you can backend the Excel to various sources via ODBC etc and it would be refreshed based on the updates to those sources, and then once it is linked properly, it will auto refresh. When you define the ODBC point to the file on the network and that would be the way to refresh to that. If the Excel is on the network, it can be shared.