Is this file saved on a local server or in Sharepoint? Are you accessing using the desktop app or the browser based excel? What happens when 2 people access together? Does 1 save and the other get an error or does 1 save and the other overwrites?If you have it on Sharepoint and ...
We keep all of our companies bank reconciled in Excel as our check register. There are 5 of us that are able to get in and add to our to this sheet and is balanced everyday. However, if 2 of us happen to get into the spreadsheet as the same time, it either saves one or the ot...
excel 2013 report report creation shared spreadsheet Replies: 0 Forum: Excel Questions D Excel Shared Workbook Hi all. I have a workbook that on most computers opens relatively quickly. One of my users when it is in shared workbook status experiences extreme sluggish stalls where after 5 mi...
Note:Access always pulls in the most recent changes from a linked document, like an Excel spreadsheet or an XML file, but doesn’t update the source file with changes you make in Access. A linked SharePoint list or Access database updates both ways. Link to data in a shared document On...
The data source for the first dashboard is an excel spreadsheet on a shared drive. The data source for the second dashboard is an excel spreadsheet on a shared drive and a sharepoint list. I was told I needed to get a gateway. I have done that. when I attempt to refresh...
Suppose your sales team is out on the road and needs to quickly get together to share information, verify quotes, and reduce overlapping effort. Think of how much more productive it would be if everyone on the team could look at and edit the same Microsoft® Office Excel® spreadsheet ...
When we share a workbook, multiple users can't work on it at the same time. Excel merges changes from one or more copies back into the one that you shared. The process works like this: You share a workbook, and as part of sharing, you save the workbook. Someone else then copies the...
Increased Load Times:Opening and saving large Excel files can take longer, especially when multiple users may be accessing the file simultaneously. Performance Lag:As the file size grows, users may experience lag and delays when navigating through the spreadsheet, entering data, or performing calculat...
Issue using varchar(max) columns in a SSIS package that creates an Excel spreadsheet Issue with SSIS package Error Code: 0xC0029151 Issue with two script components: Error Object reference not set to an instance of an object. It is already opened exclusively by another user, or you need perm...
Bug Report Details Setting up new Sharepoint site and trying to sync a large amount of local files to the Sharepoint site. The files appear to upload without an issue however I am continually getting this message: Uploaded file size does...