1. I

    Coauthored/shared workbooks?

    Good morning everybody, I am trying to set up a document that is shared by 3 users. I need the document to be present on all 3 user's OneDrives so that when we make a change to our individual version, all 3 versions will reflect the changes. Is this possible? If not, does an idea as to how this...
  2. V

    Total share in a company

    Hi, I am trying to calculate a total share in a companies for several interconnected companies. The simplified model is as follows Company/Company A B C A - 10% 10% B 10% - 10% C 15% 20% - So the company A holds directly 10% in company B which holds 20% in company A. That makes...
  3. K

    Issue with Shared Workbook (not co author)

    I have a shared excel spreadsheet (no co-author as my work is still in the dark ages) My issue is I can’t fully edit it on a computer other than the one I first created it on and neither can the authors I added I can share/unshare and edit as I please on the original computer, but If I go to a...
  4. U

    VBA - Replacing cell values based on specific range

    <tbody> A B C Oct 2019 % Share Vegetables Apples 10 50 Lettuce 10 50 Total 20 100 Fruits Oranges 10 50 Blueberries 10 50 Total 20 100 </tbody> Hi guys, little bit of an involved question here. The above is an example of my table for sales. I currently have two...
  5. K

    Rounding with exponent

    Hi everyone, this is my first post here. I consider myself an intermediate skill-level with Excel, and I use it at work quite a bit, but right now I'm stumped. In the simplest form, I'm trying to figure out a formula that will multiply a cell by a another cell which is a percentage, then round...
  6. H

    Download data from website that requires login id and password

    I want to do a macro (hopefully record macro) and need to extract data from a website that requires a password. However, my colleagues have their own login ID and password, and i do not want to share my login ID and password with them. What should I do such that i can retrieve data from the...
  7. D

    Tex & Hyperlinks Sharing Single Cell?

    Hello, Is there a way for one single cell to share both text and a hyperlink? For example, I want a cell that describes something, and then after the description, I'd like there to be a hyperlink that would access a webpage extending the topic? So the text body is separate from the hyperlink...
  8. N

    Employee "About you" Directory

    Long shot on this but i really could use some help! I'm looking for a template or someone to help me build an employee directory. I'm not sure if excel is the right medium. Currently I have A Table of contents with names listed and linked to a tab with their info. Basically a self portrait and...
  9. M

    Examples of slow/expensive to calculate spreadsheets?

    Hi, I'm conducting a performance comparison between various versions of Excel. I'm looking for real world examples of slow or expensive to calculate sheets. If anyone knows of some examples they could share that would be great. Thanks, Mark
  10. R

    No Share workbook in the review tab - protect group

    Hi , I can see only 'unshare workbook' which is greyed , how to get it to 'share'. I am unable to fix it going to the options
  11. L

    Sharing Workbook Ideas

    Hi, I have not had a viable solution to share a workbook. Does anyone know how? Thanks
  12. Jym396

    Hyperlinks for other users

    When creating a hyperlinks for other users, upon looking further, hovering over the link it shows the directories, the file path of MY computer. i'e. file///C:\Users\User\Documents\Excel\filename.xlsm. No wonder I can't share it. Thanks, ~Jim
  13. A

    Sharing a Workbook that can be filtered

    Please help! I have been searching for days to find an answer. I'm sure that I am not the first person to want to share a worksheet and allow each user to filter to their needs. There has to be a solution. So I have a worksheet that has several macros and VBA's that I would like to share and...
  14. M

    How to share Excel on Office 365 Business with some staff without email to them

    I am using Office 365 Business and my Excel file is on OneDrive. I want to share it to another staff but I do not want auto email sent to him. Is this possible Thanks
  15. A

    Share workbook that has macros and VBA

    I have a sales list that I have been working on. It has several macros and VBA to sort and filter data. I am wanting to share this list with another person to be able to update/change information. Is there a way to share my workbook and keep all of the macros and VBA functioning for both people...
  16. D

    Difficult Excel Formula - Populating Data from Drop Down Menu

    Hi All, I am trying to create a formula to have data populated from a drop down menu but I am unable to get it to work correctly. <colgroup><col><col><col><col span="2"></colgroup><tbody> Depending on which department you select, the data should automatically populate, but I am not sure...
  17. W

    sharing workbooks

    on excel 365 how do I share a wb so several ppl can view it at the same time?
  18. P


    Dear All, Just wondering about the new function in Excel for Co-Authoring, is it possible to Co-Authoring a file in the local share drive rather than cloud like onedrive? Or we need to use the old way to do the share workbook? Cheers, Peter
  19. R

    Share workbook from cloud.

    Hi all Can I share a workbook from the cloud but prevent people from downloading it or copying it? Thank you! Russ
  20. F

    Dynamic Share Array Issue

    I've got an issue with how to pull out the sum product of a value (X) set based on the share of presence of A and B respectively. The main problem is that I can't actually see A and B explicitly as shown below. Instead I've got a reference that tells me that A runs from 11/4 to 12/30 and B runs...

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