Home

Issues with shared spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-788166%22%20slang%3D%22en-US%22%3EIssues%20with%20shared%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-788166%22%20slang%3D%22en-US%22%3EMy%20first%20message%20so%20apologies%20if%20anything%20is%20wrong%20with%20the%20post.%20My%20colleague%20and%20I%20(amongst%20others)%20have%20access%20to%20the%20same%20spreadsheet%20held%20on%20a%20server.%20If%20I%20open%20it%2C%20I%20get%20the%20latest%20version.%20The%20date%20%2F%20time%20stamp%20is%20from%20when%20I%20last%20saved%20it%20(taken%20from%20Windows%20Explorer).%20If%20she%20opens%20it%2C%20it%20doesn't%20show%20any%20info%20I've%20added%20-%20the%20last%20thing%20she%20can%20see%20is%20info%20entered%20nearly%206%20months%20ago.%20The%20date%20%2F%20time%20stamp%20on%20her%20machine%2C%20in%20the%20same%20Windows%20folder%20shows%20February%202019.%20If%20she%20opens%20it%20while%20I'm%20using%20it%2C%20she%20doesn't%20get%20the%20%22Someone%20else%20is%20using%20this%20file%2C%20do%20you%20want%20to%20open%20read-only%22%20message.%20If%20she%20opens%20it%20while%20I'm%20not%20using%20it%2C%20she%20gets%20the%20version%20from%20February.%20If%20I%20open%20it%20when%20she's%20got%20it%20open%2C%20I%20don't%20get%20the%20%22Someone%20else...%22%20message%20but%20I%20get%20the%20latest%20version.%20But%20here's%20an%20even%20more%20strange%20situation.%20I%20renamed%20the%20file%20from%20it's%20meaningful%20name%20to%20%22Not%20Here%20Anymore%22%20and%20we%20got%20the%20usual%20conflicts%20messages%20and%20the%20date%20%26amp%3B%20time%20stamps%20were%20identical%20on%20both%20machines.%20Can%20anyone%20shed%20any%20light%20on%20this%20at%20all%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-788166%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-788192%22%20slang%3D%22en-US%22%3ERe%3A%20Issues%20with%20shared%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-788192%22%20slang%3D%22en-US%22%3EIf%20you%20are%20on%20Office%20365%20I'd%20recommend%20to%20save%20the%20file%20on%20OneDrive%20and%20share%20it%20with%20your%20colleague%20from%20there.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-794716%22%20slang%3D%22en-US%22%3ERe%3A%20Issues%20with%20shared%20spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-794716%22%20slang%3D%22en-US%22%3EHi%20Jan%20Makes%20sense%2C%20but%20unfortunately%20the%20spreadsheet%20is%20imported%20into%20an%20Access%20database%20and%20has%20hard-coded%20paths%20in%20the%20import%20routine.%20The%20team%20responsible%20for%20amending%20it%20don't%20currently%20have%20the%20time%20to%20do%20that.%3C%2FLINGO-BODY%3E
md69
New Contributor
My first message so apologies if anything is wrong with the post. My colleague and I (amongst others) have access to the same spreadsheet held on a server. If I open it, I get the latest version. The date / time stamp is from when I last saved it (taken from Windows Explorer). If she opens it, it doesn't show any info I've added - the last thing she can see is info entered nearly 6 months ago. The date / time stamp on her machine, in the same Windows folder shows February 2019. If she opens it while I'm using it, she doesn't get the "Someone else is using this file, do you want to open read-only" message. If she opens it while I'm not using it, she gets the version from February. If I open it when she's got it open, I don't get the "Someone else..." message but I get the latest version. But here's an even more strange situation. I renamed the file from it's meaningful name to "Not Here Anymore" and we got the usual conflicts messages and the date & time stamps were identical on both machines. Can anyone shed any light on this at all?
2 Replies
If you are on Office 365 I'd recommend to save the file on OneDrive and share it with your colleague from there.
Hi Jan Makes sense, but unfortunately the spreadsheet is imported into an Access database and has hard-coded paths in the import routine. The team responsible for amending it don't currently have the time to do that.
Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies