Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replace static data by dynamic data without loosing all the formul
Hello everybody,
I have a very complicated dashboard with formulas everywhere based on one sheet full of data. For now the data is copy/pasted everyday in it. I would like to replace the data by a SQL data connection in the same worksheet. Unfortunately when I do that all the formulas break and get #Ref instead of the actual reference. Do any of you know a way to lock all the reference during this process? Thank you for your help, T |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot charts - data disappear after selecting or data are static | Excel Worksheet Functions | |||
Dynamic data, static range, not updating. | Charts and Charting in Excel | |||
Copying data as static as source data changes | Excel Worksheet Functions | |||
Add data to cell w/o loosing initial data | Excel Discussion (Misc queries) | |||
how do I delete data from a worksheet without deleting the formul. | Excel Discussion (Misc queries) |