shared workbook

We had an issue last week where a Shared Workbook was shown as locked by a user that was not in the workbook. Is there anyway to make sure the file is released by the user? Is there any way of finding out how many shared workbooks we have on our network? Thanks, Scott

Hey there! This is my first post, and I really need some help. I've got a workbook with multiple tabs, with macros that move data back and forth between the various tabs. I need to enable multiple users to update the tool, so I set the workbook as "shared". All of the macros still work with the...

Hello all. :) I have a shared workbook saved on a network drive at my job. One of my ten columns contains a formula (the very uncomplicated WORKDAY formula.) After I fill new cells in the column with the formula and hit Save, I receive a Microsoft error message stating that Excel has...

Looking to share a spreadsheet with 100 people and allow only access to the part they should see and deny the rest, would need to be password protected as rest of data is sensitive but allow each user to make changes, any ideas gratefully received Philip

I just upgraded to Excel 2010 and noticed the following immediately. When I place an ActiveX control (e.g. a command button) on the worksheet, and then share the workbook, the button does not work any longer (as if it never gets pressed). The control works fine in the un-shared workbook. I...

Hi, I wonder if anyone can help me ... I have various different macros, all of which work well, along with my protected sheets. However when I share my workbook, the macro's do not work and the following error appears: " Run-time error '1004'; Unprotect method of Worksheet class...

So, I have this shared workbook some of some areas are protected and i have attached other word and excel documents on two of the columns so lets say M & N columns. Now when I protect and share it, users are not able to doubble click on those attachments and so they cant see those attached...

We have been using a pair of shared Excel workbook to manage a production schedule for many years, and have had very few problems. Recently I noticed that we were running in compatibility format, and since everyone was using Excel 2007 I saved the workbooks in .xlsx format over the weekend when...

Can u have 10 shared workbooks using a single source workbook, for a dropdown menu; but i need to have like 5 books open at a time from different computers over a network. Plus each one needs to have a functioning dropdown option. Can this be done?

I am working in Excel 2007 Compatibility mode. I am needing to find out how to track changes within a shared workbook (on a server) that identifies who made the changes, and I need to be the only one who gets this info. Not the others using the workbook. Is there a way that whenever ONLY I...

I am working in MS Excel 2007 using compatibility mode. Is there someone that can give me step by step instructions to protect individual cells within a shared workbook. These cells that I am trying to protect are linked to other workbooks. Thank you in advance.

We've been sharing one of our large spreadsheets between two to three users for the past 6 months or so. We've had a few bumps along the way with the maximum format errors that we've surpassed, but the one that just popped up worries me: User A is populating new rows in one of the sheets and...

I have an inventory workbook that has 7 sheets. All the sheets are protected except for select locked/unlocked cells, and use autofilter so users can only read the info, not edit. I've made a CommandButton on each sheet that resets any/all filters using VBA code in the worksheet. (by "in the...

Hi, I really hope someone can help me with this one. I'm trying to invent a spreadsheet where the users enter a timestamp when they have done their task. Everything works fine, and the spreadsheet is shared. Problem is, I think they are cheating! So I protected each sheet with a password and...

Hi guy's, I’m looking for a way for my userform to deal with conflict resolution dialogue boxes when it's saving to a shared workbook. instead of the conflict resolution dialogue box appearing I’d like to handle this within the vba code in the following way. if conflict resolution accept all...

So what it's the big mystery then... I've created an excel file with links to diffrent other files. And now when I've shared the workbook and other users are supposed to input comments in their respective sheet, some of them just disappears! Anybody who have any clue of what that's all about...

Hello: Our company utlizes a shared Excel 2003 workbook. When I unshare and make changes to the workbook, including hiding some colums in the worksheets. When workbook is shared again the columns that had been hidden in the individual worksheets are displayed again. Any help or advice on...