Pete

<div>
Thanks, we do ahve O365, we are a school but this will involve sharing, team sites, backup of onedrive (which we dont have) etc. it would be nice if we could get Excel to honour the 'in use' state and give the correct message. Why is it forgetting that someone else currently has the file open? I am hoping for a setting to stop it breaking the in use state.
</div>


Thanks, we do ahve O365, we are a school but this will involve sharing, team sites, backup of onedrive (which we dont have) etc. it would be nice if we could get Excel to honour the 'in use' state and give the correct message. Why is it forgetting that someone else currently has the file open? I am hoping for a setting to stop it breaking the in use state.

<div>
<div class="content wysiwyg-content">
Windows 2012R2 file server, Windows 10 workstations, Office 2016<br />
---<br />
<br />
Hello - Some departments have these big spreadsheets that many people work on over the course of the day. Understandably staff try and access the spreadsheet when it is open by someone else. If the first person has only had it open for a short time the second person gets the (expected) message:<br />
<br />
<i>'this is locked for editing...open read only?'</i><br />
<br />
which is what we want, but we are finding this lock seems to timeout and 2 people can open the file without any warning, work and then lose saved changes.<br />
<br />
I have tried enabling the key below on both file server and workstation to increase the share timeout to 6 hours, but this has not fixed it.<br />
<br />
HKEY_LOCAL_MACHINE\SYSTEM\<wbr />CurrentCon<wbr />trolSet\Se<wbr />rvices\Lan<wbr />manWorksta<wbr />tion\Param<wbr />eters <br />
<br />
any ideas?<br />
Thanks
</div>
</div>


Windows 2012R2 file server, Windows 10 workstations, Office 2016
---

Hello - Some departments have these big spreadsheets that many people work on over the course of the day. Understandably staff try and access the spreadsheet when it is open by someone else. If the first person has only had it open for a short time the second person gets the (expected) message:

'this is locked for editing...open read only?'

which is what we want, but we are finding this lock seems to timeout and 2 people can open the file without any warning, work and then lose saved changes.

I have tried enabling the key below on both file server and workstation to increase the share timeout to 6 hours, but this has not fixed it.

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanWorkstation\Parameters 

any ideas?
Thanks

Excel Spreadsheet Locked message does not appear

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Windows 10 is a personal computer operating system featuring the "universal application architecture" (UAP); apps can be designed to run across multiple devices with nearly identical code, including PCs, tablets, smartphones, embedded systems, Xbox One, Surface Hub and HoloLens. Windows 10 also includes a virtual desktop system, a window and desktop management feature called Task View, the Microsoft Edge web browser, support for fingerprint and face recognition login, voice-based search (Cortana), new security features for enterprise environments, and DirectX 12 and WDDM 2.0 to improve the operating system's graphics capabilities for games.

Windows 10

Microsoft Azure is a cloud computing platform and infrastructure for building, deploying and managing applications and services through datacenters. It provides both platform-as-a-service (PaaS) and infrastructure-as-a-service (IaaS) services and supports many different programming languages, tools and frameworks, including both Microsoft-specific and third-party software and systems. Cloud Services is a PaaS environment and can be used to create scalable applications and services; there are specific software development kits (SDKs) provided by Microsoft for Python, Java, Node.js and .NET. Azure also has file and storage services, data management, analytics and DNS services.

Azure

Windows Server 2016 is the successor to Windows Server 2012 R2. Built upon the same core code as Windows 10, Windows Server 2016 brings enhancements in security, servicing, and connectivity. A particular focus on this release was hybrid-cloud scenarios, and has close ties to Azure and other Microsoft cloud initiatives. This does not detract from the many improvements that are available for on-premises-only deployments

Windows Server 2016 comes in Datacenter, Standard, and Essentials editions, and for servicing, has adopted windows 10's cumulative model. The new nano-server install is designed to be remotely managed and is designed to be kept current through continuous feature updates. The full GUI install operates similarly to windows 10's "Long Term Servicing Branch" (LTSB) model with cumulative security updates.

Windows Server 2016 has also shifted from a per-processor-and-CAL licensing model to a per-core-and CAL licensing model. This brings Windows Server's licensing more in line with Microsoft's other products and makes hybrid-cloud license planning easier as well.