shared

Hi...NUB here Excel Office 2010 so I have a macro that wont work once the workbook is shared. the error is: Run Time error '1004' Insert method of Range class failed The code is: Sub INSERT_PROJECT() ' ' INSERT_PROJECT Macro ' ' Range("A2:E10").Select Range("E10").Activate...

Hi guys, I am having a bit of difficulty with a shared file I put together. I need to alter the pivots/formulas before re-sharing. Trouble is... I can't seem to make the pivots/formulas visible again. I have unshared the file so I'm uncertain why I can't edit these fields? Thanks!

I have an excel sheet that has a program to colour the Tab when either the Rows are showing Green or Red If the spreadsheet is not Shared, the formula works, but if the spreadsheet is Shared, it will not pick up the colour when any of the cells in column L are either chosen as Yes (should turn...

I am building a report with a sub report where I need to bring totals up from each group in the sub report to the main report. I have everything working on the first sub group however as soon as you start to scroll through the report it breaks. I keep reading about using a shared variable but...

In the office in which I work, many employees are using a shared personal workbook. Here's how that is set up: On a network drive, there is a PERSONAL.xlam file. A shortcut to that is on everyone's XLSTART folder. The file is updated frequently, and that was the best way I could figure out how...

Hello, I need help with data on different sheets. On the main business unit sheet named for it's VP, Murphy, I have a list of employees in column A. On the shared mailbox sheet, I have a list of shared mailboxes (SMB) owned by different employees with the name of the owner (employee) also in...

I have a workbook which about 10 teachers will want to access, quite often at the same time. Currently, only one teacher can access the workbook at the one time. I've only just heard about 'shared workbooks', so here's my question ... If teacher A only needs to add data to rows (let's say) 6...

Hi All, I want to create a search folder for the shared mail box in my outlook. However, I'm able to create a search box for my own email but when I try do the same for the shared mailbox it keeps defaulting to my own mailbox to look up for folders to search in. A google search doesn't provide...

Dear all, For time-sheet calculation purposes, need to determine the number of hours shared between two time intervals; in this new case, I need to correctly determine the values in cells H17 & H18. Some background: I need to calculate multiple hours a shift 'shares' with multiple 'Periods...

</C:\users\bftd\desktop\vba>Hi Guys, I have read other threads like this but the solutions doesn't work in my situation, I'm not sure what's the reason..im a newbie here.. What I'm looking for is a macro that copies mails from a shared group mailbox to excel .We're using Microsoft outlook...

Office 2010, Windows 10, An Excel Shared workbook being used by 12 Users stored in a shared folder on the network server. The issue is when a user tries to save the workbook after making their changes, they get the following error message. Then they have to close the file and lose their...

Hi All, We currently have a large shared workbook (I know!!) which has multiple tabs for each month from Jan 2016 to Dec 2017. The workbook is accessed by several people in different time zones multiple times throughout the day. As you have probably guessed, it's becoming a bit unstable and I'm...

Hi all, I have a shared workbook which I would like my collegues to keep open at all times, and they can add information to it via a userform. In order to ensure there aren't any data clashes, they have to "refresh" the sheet before adding which uses this simple code: Sub Refresh()...

Hi guys, Background: I have created an excel file which allows my collegues to input various bits of news, and wanted to make it as simple to use, with restrictions, so use a userform. I also wanted them all to be able to keep it open, so made it a shared document. In order to get around the...

I'm new to vba. I have a shared workbook with VBA macros. The first execution of the code works in a timely manner, however, subsequent executions takes minutes to complete (if it even completes). I have been removing code little by little to find the culprit. A snippet is below. daysAhead...

<tbody> <tbody> ID number </tbody> <tbody> Fruits </tbody> <tbody> id100 </tbody> <tbody> Banana, Strawberry, Melon, Apple </tbody> <tbody> id100 </tbody> <tbody> Banana, Strawberry, Apple, Carrot, Broccoli </tbody> </tbody> Hi, I'm trying to find all 'ID...

Hello, First timer here in the forum, but I was wondering if it is possible to create a shared workbook within Excel. By this I mean can I create a workbook that a friend has access to and can make changes to. And when he does, those changes appear in my "shared workbook"? I appreciate any help...

Hello, Three of my users (Amanda, Beth, and Rose) have a shared spreadsheet file. It is a large file with 30 tabs and ton of information. Last week they took 10 tabs each and did their edits. Whatever data three of them entered or edited, got saved and shows up on each computer when they...

Hi guys, I have a mystery which I'm hoping someone will help me solve. I have a workbook which needs to be shared. It relies heavily on VBA functionality. In order to avoid save conflicts in certain specific cells which don't need to be saved (custom search boxes, stats dropdowns etc) I built...

Hello fellow Excel guys, I'm a developer for my company, and we use a shared workbook which is accessed by several people through the day. It relies heavily on VBA (so much so that I have separated out the code into an .xlam add-in which is referenced from the main file, in order to keep the...