shared

  1. s_macloskey

    Share Workbook (Legacy) problem.

    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...
  2. M

    Open another Workbook and apply filter

    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...
  3. J

    VBA email with hyperlink to shared drive

    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:\...
  4. K

    Error 1004 - Add Hyperlinks to a range with Cell Value in string on Open - Doesn't work when opening in Shared Mode

    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...
  5. S

    Can pivot tables in worksheet be shared in another excel workbook and changes dynamically?

    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...
  6. F

    How to track changes of a shared workbook in a separate workbook

    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...
  7. K

    Macro running on Shared workbook (Sharepoint)

    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...
  8. 2

    MS Access auto/scheduled report export.

    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...
  9. M

    Shared Workbook on one user not saving

    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.
  10. S

    Upon Saving Workbook, Reset Filters in Shared Workbook

    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...
  11. W

    Create user-generated or auto-generated report from password-protected shared spreadsheet Excel 2013

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

    Excel Shared Workbook -- slow/stalls in opening

    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...
  14. jmacleary

    Adding a new query to a shared workbook (OK I know they're bad!)

    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...
  15. P

    Inserting a link to a URL

    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...
  16. T

    Auto click refresh all icon when table values change

    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...
  17. C

    Shared Workbook from Template

    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...
  18. R

    Shared workbook settings

    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...
  19. S

    I want to avoid other users to hide rows in a shared Excel file

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

    Avoid row hide in a shared Excel file

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top