Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
structured references with externally linked excel tables
I have a table that is connected to a sharepoint website that I would like to
be able to reference throughout the rest of my workbook, and have all of the other data update when I refresh the original table. Currently, whenever I refresh the table all of the other references shift down to the blank cells below the original data table. I have tried using hlookup, vlookup, hlookup, index, and other reference formulas in conjunction with many other formulas to try and have the other data update with the original data, but it doesn't seem to work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Structured references in custom Data Validation expression? | Excel Discussion (Misc queries) | |||
Structured References - Regression Analysis | Excel Discussion (Misc queries) | |||
Excel 2007 chart series - unable to use structured references | Charts and Charting in Excel | |||
Structured references & Quickbooks data | Excel Worksheet Functions | |||
using wildcard characters for filenames in externally linked files | Excel Discussion (Misc queries) |