said by compugeek0:...This spreadsheet is on a remote file server and about 1-5 people at a time could be in it. How do you add a "recalc" to a web query? I don't know where it would store the data in excel? I see you can store a query locally, but that doesn't help the other people use it.
I'm not sure that you can implement any kind of recalc command within a webquery .iqy file.
Usually the values accessed by a spreadsheet from a website via a webquery are transferred into a spreadsheet to some kind of target data table. If that transfer involves numerical or textual alterations to existing cell-values in the targeted storage range, that overwriting should of itself trigger an auto-recalculation of the sheet (assuming it's turned on), regardless of whether additional cell cosmetic attributes are involved. Sometimes, it may be necessary to have a simple dummy formula in a cell somewhere outside the data table refer directly to the values of all data-table cells in such a way that a change to any data table value forces the results of the dummy equation to change, and sheet recalculation can be forcibly auto-triggered in that way. (eg: =sum(
first-table-cell-address.last-table-cell-address) Even if the dummy equation evaluated incorrectly or to an error, recalc should get triggered if the data in the table range changes.
Is the data being downloaded via web-query to the spreadsheet purely of a cosmetic nature, at the cell level of each cell?
edits: clarity... I hope!