D
Dave_in_gva
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
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