shared

  1. 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:\...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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.
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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.
  18. 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.
  19. W

    macros on shared file, UserInterfaceOnly

    Hello all, I have a tracker file opened with user form login and showing/hiding individual sheet for each user. This file needs to be shared. The original code is using .protect and .unprotect to execute macros and vba changes on one of the sheets, which does not run on the shared file. Getting...
  20. Z

    Looking for opinions on Shared Workbooks

    Hi, All... Background: I have a LAN-based Shared workbook that occasionally becomes corrupted after users go in and change formatting and add highlights. When this happens, I need to do some manual workaround for my VBA to run the next day. The "shared" aspect is mandated by management and I...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top