LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > General
User Name
Password
General This forum is for non-technical general discussion which can include both Linux and non-Linux topics. Have fun!

Notices


Reply
  Search this Thread
Old 10-04-2017, 10:04 AM   #1
PoleStar
Member
 
Registered: Jul 2010
Posts: 170

Rep: Reputation: 2
Excel sheet does not fetch fresh copy off the network


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.
 
Old 10-04-2017, 12:46 PM   #2
sevendogsbsd
Member
 
Registered: Sep 2017
Location: Texas
Distribution: Void
Posts: 91

Rep: Reputation: Disabled
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...
 
Old 10-04-2017, 01:41 PM   #3
273
LQ Addict
 
Registered: Dec 2011
Location: UK
Distribution: Debian Sid AMD64, Raspbian Wheezy, various VMs
Posts: 6,848

Rep: Reputation: 1952Reputation: 1952Reputation: 1952Reputation: 1952Reputation: 1952Reputation: 1952Reputation: 1952Reputation: 1952Reputation: 1952Reputation: 1952Reputation: 1952
With no clue as to which software, OS or network setup is in place this thread is pointless.
please provide actual information.
 
Old 10-05-2017, 03:29 AM   #4
AnanthaP
Member
 
Registered: Jul 2004
Location: Chennai, India
Distribution: UBUNTU 5.10 since Jul-18,2006 on Intel 820 DC
Posts: 849

Rep: Reputation: 201Reputation: 201Reputation: 201
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
 
Old 10-06-2017, 03:59 PM   #5
dave@burn-it.co.uk
Member
 
Registered: Sep 2011
Distribution: Puppy
Posts: 353

Rep: Reputation: 133Reputation: 133
It also requires the access to be EXCLUSIVE access to stop someone else also accessing it.
 
Old 10-06-2017, 06:37 PM   #6
John VV
LQ Muse
 
Registered: Aug 2005
Location: A2 area Mi.
Posts: 17,218

Rep: Reputation: 2517Reputation: 2517Reputation: 2517Reputation: 2517Reputation: 2517Reputation: 2517Reputation: 2517Reputation: 2517Reputation: 2517Reputation: 2517Reputation: 2517
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 ?

Last edited by John VV; 10-06-2017 at 06:39 PM.
 
Old 10-06-2017, 06:45 PM   #7
dave@burn-it.co.uk
Member
 
Registered: Sep 2011
Distribution: Puppy
Posts: 353

Rep: Reputation: 133Reputation: 133
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.
 
Old 10-07-2017, 03:51 AM   #8
AnanthaP
Member
 
Registered: Jul 2004
Location: Chennai, India
Distribution: UBUNTU 5.10 since Jul-18,2006 on Intel 820 DC
Posts: 849

Rep: Reputation: 201Reputation: 201Reputation: 201
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

Last edited by AnanthaP; 10-07-2017 at 03:56 AM.
 
Old 10-07-2017, 12:51 PM   #9
dave@burn-it.co.uk
Member
 
Registered: Sep 2011
Distribution: Puppy
Posts: 353

Rep: Reputation: 133Reputation: 133
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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] how to select slopely in excel sheet? p\_/ppy Linux - Newbie 1 03-26-2017 12:26 PM
How to copy Arabic data from excel fiel to another excel file in PERL? David the H. Linux - Newbie 0 04-23-2012 10:24 AM
i want c program for fetching data from excel sheet rinu budhbhatti Programming 3 01-31-2011 09:23 AM
how to import MS-Excel sheet data using PHP dileepkk Programming 1 07-28-2004 03:23 PM

LinuxQuestions.org > Forums > Non-*NIX Forums > General

All times are GMT -5. The time now is 12:55 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration