| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Query to Ex Data refresh changes formulas
I have a sheet DATA that contains a reference to an external data source. On
another sheet SUMMARY i have formulas that reference the cells in DATA. Since i am not sure how many rows the data will occupy, i have the formulas set to reference $A$1:$A$5000. there will never be more than 5000 rows of data. However, when i refresh, my formulas get changed if the data changes and now say $A$1:$A$5327. I guess this is ok, but they are big array formulas and i have to set calculation to manual. I am trying to keep the calculation speed optimized. is there a way to keep the formulas constant? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Query doesn't add/delete data in rows on refresh | Excel Discussion (Misc queries) | |||
| external data automatic refresh through macro/query | Excel Discussion (Misc queries) | |||
| How can I 'Enable Automatic Refresh' for Query Refresh by default | Setting up and Configuration of Excel | |||
| Data Query will not Refresh automatically | Excel Worksheet Functions | |||
| Prompting to allow External Query Data Refresh | Excel Discussion (Misc queries) | |||
Linear Mode
