Solved

Update Excel tab

Posted on 2011-03-02
2
298 Views
Last Modified: 2012-07-31
I have an excel file that I use as a template. The First tab contains blocks of data a4:b8 with an associated Graph linked to that block below it. Now I have the a4:b8 block being fed by the second tab for data. I have 5 sets of these. I use access to create the data and export it to the second tab which feeds the first tab and the graphs. Well it works great (almost). All five sets of blocks update to the new data no problem however the last two graphs do not update with the new data. If I go to the second tab and copy and paste the same data thats there it then resets the graphs. Any suggestions on how to fix this with access vba code so its done automatically right after I export the data so theres no need to go back in and recopy and paste the data ?
0
Comment
Question by:Grizbear51
2 Comments
 
LVL 12

Accepted Solution

by:
Amick earned 500 total points
ID: 35024334
Have you tried worksheets.calculate  and chart.refresh?
0
 

Author Comment

by:Grizbear51
ID: 35047539
I am assuming I have to open the spreadsheet with code to do the worksheet.calulate or chart.refresh correct? Or can you do it directly with vba?


0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question