Excel sheet does not fetch fresh copy off the network

PoleStar · 10-04-2017, 09:04 AM

Hi,

When ever I open excel sheet it all most never have current data.
Also today is oct 4th, but on properties I see

"‎Accessed Monday, ‎October ‎02, ‎2017, ‏‎3:45:59 PM"

while I AM accessing it right now.

Please help.

sevendogsbsd · 10-04-2017, 11:46 AM

Try copying the file to your workstation and editing it there, then copy back to the network location? We have tons of issues with microsoft office files on a windows network. Ironic, yes...

273 · 10-04-2017, 12:41 PM

With no clue as to which software, OS or network setup is in place this thread is pointless.
please provide actual information.

AnanthaP · 10-05-2017, 02:29 AM

Generally, I think it's fair to assume that the time of last access is updated only once the file is closed. That may be so even for local files.

OK

dave@burn-it.co.uk · 10-06-2017, 02:59 PM

It also requires the access to be EXCLUSIVE access to stop someone else also accessing it.

John VV · 10-06-2017, 05:37 PM

PoleStar seeing as excel is a Microsoft program
and you need to be using a microsoft Operating System to use it

i would not expect it to get things from any non microsoft network

so

How are you running Win 10 ( or 8.1 ) to run Microsoft Office ?

dave@burn-it.co.uk · 10-06-2017, 05:45 PM

The program is part of Microsoft's Office suite and does run under Windows OR a Windows emulator, BUT, the spreadsheets it produces can be read and updated by several open source programs both under Windows AND Linux.

AnanthaP · 10-07-2017, 02:51 AM

It's LAST ACCESSED and not NOW ACCESSING.

But

What result does ${stat filename} give when the file is kept open using openoffice, libreoffice, gnumeric etc?

OK

dave@burn-it.co.uk · 10-07-2017, 11:51 AM

I've just just remembered that office takes a copy of the file while it is working on it and keeps it in the office temp folder.
If the application crashed and left that copy around, the original may well be inaccessible until it is repaired or removed.