shared

Hello Team, I've been struggling with this all week, and am running up against a deadline to make this work for my team. Here are the essentials: The MS 2021 Access DB sits on a SharePoint Server; The SharePoint permissions have been granted to Everyone; The code updates with a new record...

Good morning all, Shared Workbook Legacy doesn't seem to work for me any longer. I've copied and updated a daily payments sheet (from a 97-2003 sheet), almost cell-for-cell. I use the Share Workbook button, select "use the old shared workbooks feature" and save the sheet. But; when another...

Hi all, whit this code I would like to open another Excel Worbook (which is locked and shared) if not already opened and apply the filter on Worksheet named "1" to the cell A1 (cell A1 is a header, but it is not a table just a range). So basically after filter is done I want to see only numbers...

So I have a spreadsheet that sends an automated email - no problems there. I've run into a small issue when I want to insert a link to a folder on a shared drive. I have the code set up so the message body writes, ... update your training file at: S:\Training\Staff Training... where the S:\...

Hi, I have the following piece of code running when opening a workbook. I want this workbook to be shared, but when I open in shared mode this piece of code gives me a run-time error '1004': Application-defined or object-defined error. Works fine when not in shared mode. I have googled...

Hello all, I have a workbook with about 10 worksheets. One of the worksheets contains pivot tables and slicers. I would like to check if it is possible share/extract this worksheet with pivot tables on another excel workbook, and that changes will be updated dynamically. Reason being I would...

Hi All, Is there any chance to track the changes of a shared workbook in a separate workbook. Since the workbook needs to be shared with 20 users and adding the code to the same workbook will slow down the file. Since the file consists of 10 excel sheets. Please help in adding a code to...

Hi everyone, Has anyone had any experience of running macros on a shared workbook? I know that array formulas cause shared issues if they are not locked down and protected before sharing it but what happens when I was to run a few macros? I have a workbook which will be used on a daily basis...

Hello All, Is it possible to run MS Access report export (to MS Excel) by a user that does not have MS Access? I need to share report that uses data over ODBC to multiple remotely located users. Not all of them have MS Access. I was wondering if there was a way they could run export that would...

we are using a shared workbook and one of the users has the autosave button in the top left corner. I don't have that and i am able to save mine. But she can't and isn't getting updates.

I have the below code which will automatically reset filters when saved. However, I need this to operate in a Shared Workbook. How can I get the filters to reset when the workbook is saved, in a shared workbook please? Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As...

My healthcare facility currently used a shared, password protected spreadsheet to schedule procedures for physicians. Is there a way I can create a user-generated report (basically a daily schedule) from the spreadsheet? I've attempted to link data to another workbook and/or create a linked...

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 minutes it still has not completed opening. (This is a new problem, he never had a problem before) When we tried a...

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 minutes it still has not completed opening. (This is a new problem, he never had a problem before) When we tried a...

Hi folks. For my sins I maintain a large number of excel workbooks, several of which are shared. These shared workbooks were written using (I think) excel 97 and have some msqueries in them, which run fine each time the workbook is opened. I now need to add another query, but excel 2007 (my...

Hello, I insert links to webpage URLs to have access to references. The links work perfectly in the local drive but when I store the file in a shared drive for other users to get access then the links error out. Please let me know how I can insert these links so I can have access in shared...

Hi , Hope you are all good.. Urgent help.. I have created a access database. It has 6 table. have not created ant forms and quires. Users update data manually because it is shared database. like shared excel Requirement is , If any one change any value or update any value in any table...

Hello, Not sure if this is possible, but what I am trying to do is set up a template, that when a new workbook is created from this template, that workbook is shared. My employees open a new document each day to record a lot of data but I would like to be making changes on that document at the...

This issue is a bit difficult to explain. Essentially I'm having issues finding shared & protected workbook settings that fit my teams need. Requirement: 1. I need this file to be shared so multiple people can go in at the same time and make changes to un-protected cells. 2. ALSO need this...

I want to avoid other users to hide rows in a shared Excel file. How should I proceed? Thanks.