+ Reply to Thread
Results 1 to 2 of 2

Need full refresh to rebuild my file

  1. #1
    Registered User
    Join Date
    10-08-2014
    Location
    Yerevan, Armenia
    MS-Off Ver
    2010
    Posts
    4

    Need full refresh to rebuild my file

    Hi,

    After unzipping xlsx and modifying many stuff in xmls(both changing formulas and changing inputs of chart series and so on) I need to refresh my excel file fully.

    Alt + Ctrl + Shift + f9 (Application.CalculateFullRebuild) is doing it partially, it updates values of formulas. But my charts are not showing the updated results. Actually I understand the reasons are coming from xmls that I should provide more time there modifying other values which are related directly to GUI, but solving it will be too much time consuming.
    One way to solve it is, I am saving my file then reopening it, and they are ok (excel creates all connections correctly and modifies all data while saving), otherwise I have to delete each series and create it again to see it correct. Is there anyway to refresh my xlsx by vba or manually, but not save and reopen, because all my scripts should be used by other users and do not want to make extra inconvenience for them, such as open xlsx, refresh, save, then reopen then use another vba...

    Thanks in advance,
    Sam
    Last edited by samvelt; 10-08-2014 at 05:27 AM.

  2. #2
    Registered User
    Join Date
    10-08-2014
    Location
    Yerevan, Armenia
    MS-Off Ver
    2010
    Posts
    4

    Re: Need full refresh to rebuild my file

    Oh found solution, didnt know VBA can save by a command I am new in VBA
    ActiveWorkbook.Save did it normally

+ 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. Replies: 4
    Last Post: 01-09-2014, 09:03 PM
  2. Chart doesn't refresh after VBA rebuild
    By B.Jones in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 01-07-2014, 05:04 AM
  3. Macro to full in data from Master file to a daily recon file
    By Dnels in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-21-2013, 12:03 PM
  4. Replies: 12
    Last Post: 01-30-2013, 07:32 PM
  5. Bad rebuild of screen after refresh data
    By KoenD in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-02-2010, 01:22 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