Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
New worksheets in a webquery.xls not automatically refreshing
Hi there,
I have a workbook file which automatically refreshes wine consumption data from a web based source on the basis of my logging in via a Login worksheet in the workbook. Once I log in, all worksheets in the workbook update from a web based data source(including separate worksheets for wines consumed and wines in stock). I have added a new worksheet to the original webquery.xls file which totals consumption of wines per year and bottle availability by year. The formulae for these calculations make use of the automatically refreshed values within the workbook on the other original worksheets. A chart has also been added which graphs these newly created total values, giving me a graphical representation of my consumption and bottle availability by year. When I save this workbook file, subsequently reopen it and go through my log in, the data on all of the original worksheets refreshes from the internet, and updates my wine inventory and consumption figures on the respective worksheets. What it does not do, however, is update my newly created total consumption and bottle availability by year worksheet, nor the chart worksheet which graphs these totals. Tools¦Options Calculation is set to automatic, and pressing F9 does not do anything. I am using Excel 2003. Does anyone know how I can set up this workbook file to automatically update and refresh my new worksheet additions when the workbook refreshes? Thanks for all comments, Dave M |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically Refreshing Data at 12am | Excel Discussion (Misc queries) | |||
Automatically Refreshing Data at 12am | Excel Worksheet Functions | |||
Automatically Refreshing Data at 12am | Excel Discussion (Misc queries) | |||
Automatically Refreshing Data at 12am | Excel Worksheet Functions | |||
Pivot Tables are Automatically refreshing | Excel Discussion (Misc queries) |