+ Reply to Thread
Results 1 to 3 of 3

Macro asking to manually update values

  1. #1
    Registered User
    Join Date
    08-11-2016
    Location
    MN
    MS-Off Ver
    07' 13'
    Posts
    2

    Macro asking to manually update values

    Hi there,

    I have a Microsoft workbook data spreadsheet (also macro enabled) that I'm referencing with a macro enabled workbook. When running the two spread sheets on the same PC, the macro enabled workbook is updating automatically with no issues. When running the workbook on a separate computer, upon saving the workbook the macro enabled workbook is asking to update the values and forces me to select the data spreadsheet, much like opening an existing file. I want the macro enabled work book to not ask to reopen the file when the data spreadsheet saves much like it would if the same PC had both spreadsheets open. Is this possible? The macro enabled workbooks macro is simple:

    Please Login or Register  to view this content.
    Thank you in advance,

    Kyle
    Last edited by kbrown825; 08-11-2016 at 04:05 PM.

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Macro asking to manually update values

    Moderation removed. code tags are added.
    Last edited by Winon; 08-12-2016 at 06:32 AM.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Registered User
    Join Date
    08-11-2016
    Location
    MN
    MS-Off Ver
    07' 13'
    Posts
    2

    Re: Macro asking to manually update values

    Thanks, updated.

+ 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. A manually entered cell to automatically update another manually entered cell
    By Head Scratcher in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-29-2013, 08:23 PM
  2. Detect manually entered numbers and update other formulas accordingly
    By dougmcc1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-17-2012, 08:02 PM
  3. search/manually modify and update record
    By belkin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-07-2011, 04:12 AM
  4. Changing Manually entered matrix values via macro
    By Blailus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-17-2008, 11:18 PM
  5. How to update one manually-entered value from another?
    By 1robc57 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-02-2006, 01:10 AM
  6. I can only manually update?
    By jclark419 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2005, 01:05 PM
  7. Manually Update Listindex
    By DB in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-11-2005, 12:05 AM
  8. [SOLVED] Manually update links
    By Emma in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-22-2005, 10:06 AM

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