| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Updating data from other Excel workbooks/Worksheets
Hi
I've created a workbook (let's call it Bucket) which fetches data from some linked workbooks. However when I open Bucket I get error message '#VALUE!'. What I have done is add a formula which is supposed to to do some calculation in the other worksheet and then update information in Bucket. Refreshing does not work and I've already changed the trust center settings to automatcially update the data links. What should I do...? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Updating data from other Excel workbooks/Worksheets
Just a note: When I open all source files from "edit links" the data gets
updated. "Asim" wrote: Hi I've created a workbook (let's call it Bucket) which fetches data from some linked workbooks. However when I open Bucket I get error message '#VALUE!'. What I have done is add a formula which is supposed to to do some calculation in the other worksheet and then update information in Bucket. Refreshing does not work and I've already changed the trust center settings to automatcially update the data links. What should I do...? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Overwriting data in other worksheets while updating another | Excel Discussion (Misc queries) | |||
| Automatically updating data between worksheets. | Excel Discussion (Misc queries) | |||
| Copy/ move selected data from workbooks to seperate worksheets or workbooks | Excel Worksheet Functions | |||
| Updating Pivot Table Data automatically from external workbooks | Excel Discussion (Misc queries) | |||
| Automatic updating worksheet data between different workbooks | Excel Worksheet Functions | |||
Linear Mode
