Results 1 to 4 of 4

Stopping cells from automatically refreshing after external data refreshes

Threaded View

UNWATCHABLE Stopping cells from... 01-30-2010, 10:42 PM
teylyn Re: Stopping cells from... 01-30-2010, 10:52 PM
UNWATCHABLE Re: Stopping cells from... 01-30-2010, 11:21 PM
UNWATCHABLE Re: Stopping cells from... 01-30-2010, 11:36 PM
  1. #1
    Registered User
    Join Date
    01-02-2010
    Location
    my room
    MS-Off Ver
    Excel 2007
    Posts
    15

    Wink Stopping cells from automatically refreshing after external data refreshes

    I have 2 Excel documents.

    The first document is named "data" and it extracts data from off the Internet every 24 hours.

    The second document, named "database", is for storing this data. Every 24 hours, I run a macro which imports the data from "data" into a new row in "database", along with the date the macro was run.



    My problem is this: Whenever I refresh the external data in "data", my "database" document also refreshes itself instantaneously.

    My question is this: Is there a way to "cut the connection" between the two documents so that, when "data" is refreshed, the data in "database" DOES NOT also refresh itself automatically?



    Thank you in advance
    Last edited by UNWATCHABLE; 01-31-2010 at 12:00 AM. Reason: Solved

Thread Information

Users Browsing this Thread

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

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