+ Reply to Thread
Results 1 to 3 of 3

refreshed excel doc with preserved formulas?

Hybrid View

  1. #1
    Registered User
    Join Date
    08-24-2014
    Location
    San Francisco
    MS-Off Ver
    2007
    Posts
    2

    refreshed excel doc with preserved formulas?

    Hi - I have a refreshed report that I pull in daily/weekly from our HR system. How can I preserve the formuals within the template? After each refresh, all the formuals get wiped out. Any help is appreciated!

    Thank you.

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: refreshed excel doc with preserved formulas?

    I think that what you need to do is to start the macro recorder.

    And step through the spreadsheet and fill the formulas in each cell.

    Stop the recorder.

    Import your new data.

    Run the Macro,

    Your formulas should be reinstated.

  3. #3
    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
    53,044

    Re: refreshed excel doc with preserved formulas?

    perhaps have the formulas on a different sheet (or even different WB)?
    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. Excel 2010 pivot table formatting not preserved after update
    By MARKSTRO in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-30-2013, 01:37 PM
  2. Formatting not preserved in web query Excel 2007
    By Methodician in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-05-2013, 01:36 PM
  3. Replies: 1
    Last Post: 08-22-2012, 07:46 AM
  4. Excel 2007 : pivot chart size not preserved in template
    By chicagoman in forum Excel General
    Replies: 0
    Last Post: 02-10-2009, 12:30 PM
  5. Replies: 1
    Last Post: 04-15-2005, 06:06 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