+ Reply to Thread
Results 1 to 2 of 2

New workbook with no Add-ins

  1. #1
    Registered User
    Join Date
    02-21-2015
    Location
    Australia
    MS-Off Ver
    Excel - 2016 PC Vers 16.0.5404
    Posts
    14

    New workbook with no Add-ins

    I have a workbook with several Add-ins and conditional formatting but no vba.

    I want to share out a copy of just 1 sheet to a new workbook to share with others in my team. Users on other machines will open a read copy from a network file share but are unlikely to have the necessary add-ins for it to calculate the sheet.
    So basically i want to somehow reference all data to my master copy.

    So they open the file, and the data displayed is exactly what's on my master copy. I've tried a copy/special paste etc but it's still missing data.
    is this possible?

    Basically my workbook will do all the heavy lifting.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: New workbook with no Add-ins

    Could you make a "dumbed down" version of your main file, just reference the data they need and then share that file with them?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copy 2 tabs from Workbook A to new workbook then close Workbook A without saving
    By ellenlewis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-21-2023, 02:55 PM
  2. Replies: 5
    Last Post: 08-02-2021, 06:14 AM
  3. Assign name to Workbook, Copy range from one workbook to another workbook
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-18-2015, 03:40 AM
  4. [SOLVED] VBA to open new workbook and run macro from new workbook, which closes old workbook
    By Rerock in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-26-2014, 10:45 AM
  5. [SOLVED] Code to cut cell from one workbook, close same workbook, and paste in different workbook
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 03-13-2014, 04:01 PM
  6. Copy data one workbook to another workbook without opening workbook
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-04-2014, 11:28 AM
  7. [SOLVED] Copy Values From Each Workbook in Folder to a Single Sheet in New Workbook +Workbook names
    By Arsham24 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-21-2012, 07:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1