share

  1. L

    share workbook, protect workbook/sheet sequence

    Hi If I click on Share Worksheet then Protect workbook/sheet will be grayed out. so I should first pportoct workbook/sheet firs then share. What is the idea behind this sequence.? Thank you very much
  2. E

    Share user form on One Drive?

    Is it possible? thanks.
  3. M

    How to get a file to auto update fron a shared file.

    Ok, This not so easy in my case. I have a shared file with shapes on multi monitor for each working position as a share file. To edit shapes you have to un-share the file, that I do in code and re-share in code when complete (10-30sec). My problem is the when on share I lose the...
  4. N

    how to share a document so that multiple users can update the data

    I have an excel file and i want to share it with specific users so that they can update the inputs in the same excel file.
  5. C

    Formula for Weighted Share Based on Ranking

    I am looking for a formula for "Weighted Share Based on Ranking". Any help would be appreciated. Thanks! <tbody> Doctor Ranking Weighted Share Based on Ranking Smith 1 1.05 Jones 2 1 Johnson 3 .95 </tbody>
  6. V

    find particular words and do the action..

    Dear All, In my Col A, I have fixed words, which I want to make them in small letters only. words are, Col A contains statements, any statements wherein, the above words are there...and they should remain in small letter... Pls share the code...
  7. G

    Multiple Table download from the internet to Excel Yahoo Finance Japan

    Dear All, I hope you can help me I am trying to download historical share data for share 8088 from yahoo Japan. The first page of the table I need is in the following location: - https://info.finance.yahoo.co.jp/history/?code=8088.T&sy=1983&sm=11&sd=19&ey=2017&em=12&ed=19&tm=d&p=1 I then...
  8. F

    Calculating Opportunity Gap within Pivot Table

    Hi, I've been struggling with this for a while, but I am trying to do a Opportunity Gap calculation within the pivot table. Below is how i have my data laid out. I am able to calculate $% Change, Retailer's Share (TY/LY) and the Share Point Change all within the Calculated Field portion. But...
  9. N

    Sharing Excel Workbook With a Table

    Excel will not let me share a workbook with a table that has been created. To share it I need to convert the table to a range, this reduced the functionality of my worksheet. I have to share the workbook so that I can track changes. I need to see a history of various values that have been...
  10. J

    How to use workbook via shared network to Open/Save

    Hello all, actually im from excel forum and im post this problem but no response.. my problem is i have a two excel file with a userform connect each other and i want the one excel file to use in other computer. i try share workbook and folder shared but same failed. how to use my excel in a...
  11. A

    Rotating Schedule based on Unit Volume Share

    <tbody> A B C Week 1 Week 2 MFG A MFG B MFG C MFG A MFG B MFG C MFG A MFG B MFG C Bananas .6 .2 .2 ON Apples .1 .4 .5 ON Oranges .3 .5 .2 ON </tbody> Columns A,B and C represent Percentage of Unit Volume by MFG for the Fruits to the left. Using...
  12. G

    VBA macro to remove rows if column has value?

    Hello, I want to know if theres a marco that can do this and if so, please share. I want rows that contain any value other then 0 to be deleted. Thanks in advanced.
  13. tamrob23

    Share Workbook Not Available

    Good Afternoon, Myself and two other coworkers are working in an Excel workbook and now we are trying to share the workbook and it is "greyed out" (option not available for selection. There are no external links in the workbook, we all tried the select shared, even the creator but he cannot...
  14. S

    Cheat Sheet

    How many of you keep a cheat sheet with your most used and most useful formulas/macros on it? Just curious. I've been thinking of starting one instead of trying to remember them, and remembering them wrong most of the time. That really makes me look good..."Hey, can you help me do such and...
  15. H

    Excel VBA Loop to create column header variables

    Hi guys, Has anybody ever written a loop that will make an INTEGER variable out of each column header in a worksheet? If so, could you please share the method? thank you!
  16. M

    create a summary table from another table and add formulae

    I have a table with a share portfolio on one sheet which includes the stock name and book values amongst other columns. Some stocks appear more than once (intentionally). Shares come and go so the table changes regularly. From that table's data, on another sheet I want to summarise the total...
  17. S

    Share a locked down pw protected Excel model

    I need to share a complex model with potential clients while at the same time keeping it secure. I've been using the excellent program XLS Padlock, but now many IT departments are blocking all .exe files (even camouflaged ones) via download or even usb drive. Short of mailing the client a...
  18. M

    vba notes / audio/ video for beginers.....

    Hi Team, I am new to VBA , Just started learning, if anyone has notes on vba, ya simple video to understand it. Please share. my mail id - mallesh_gangadhar54@yahoo.co.in Thanks a lot in advance !!! Regards, Mallesh
  19. M

    Share the Excel File with SQL connections

    I need some urgent help. I've created a search tool in excel which pulls some information based on the search criteria from SQL. I've used SQL VBA method to retrieve the information. It works fine on my system. However, I want to share this file on server or network so multiple users can...
  20. RyanTG

    Any hacks for sharing excel workbook with multiple users?

    After scouring forums, I have yet to find a solution to sharing an excel workbook without losing several features (Eg: macros, tables etc). I have built a Customer Relationship Management (CRM) system within excel and have a need to share it with three other users. Unfortunately, many of the...

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
Back
Top