+ Reply to Thread
Results 1 to 1 of 1

Data Connections : Saving history before refreshing?

  1. #1
    Registered User
    Join Date
    canton, ohio
    MS-Off Ver
    Excel 2010

    Data Connections : Saving history before refreshing?


    How can I easily save a sheet tab before I refresh a data file?

    I have several spreadsheets currently with a REFRESH tab, and then date tabs for every day I refresh the data - in order to follow the history, look back at last weeks data to compare, etc.
    What I currently do is refresh data > copy entire sheet > paste into a new sheet tab > save
    Doing this, however, makes my connections add up, each time I paste the data, it adds that data file to a new connection, leaving me with a list of connections. (ex. say data.txt is my external source. when I paste the sheet that creates, it makes a new connection to a file data1.txt, data2.txt, etc)

    I want to be able to open my spreadsheet, refresh my REFRESH tab, move the data to a new tab without creating so many different connections.

    Does this make any sense?

  2. #2
    Valued Forum Contributor
    Join Date
    Eastbourne, England
    MS-Off Ver
    Excel 2010

    Re: Data Connections : Saving history before refreshing?

    Hi brianlg

    Yes, it makes perfect sense.

    The way I would do it would be as you are doing, but in the new tab paste > special > values only.


+ 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. Safe way to refresh many connections without saving the password?
    By bristly in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-24-2013, 06:29 AM
  2. Replies: 2
    Last Post: 05-24-2012, 08:43 AM
  3. Pulling Web Data and saving History
    By filcaiado in forum Excel General
    Replies: 0
    Last Post: 04-19-2012, 08:03 PM
  4. Refreshing workbook connections
    By Thamizh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-04-2010, 01:30 AM
  5. History worksheet - can it remain viewable after saving?
    By plngarbage in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-15-2006, 10:15 PM


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