Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Linking two spreadsheet, pulling data from one cell to another, data is being truncated
I've got a spreadsheet setup that reads data from another
spreadsheet. Each time I open my spreadsheet, it asks if I want to update values and I say yes. The problem I'm having is it is truncating values of text being pulled in. If I open up the second spreadsheet, it seems to correct itself. I've got one to many spreadsheets setup, so opening each one is not really an option. Is there anything I can do to force it to read correctly? Something from the master spreadsheet that is reading from the others. Sample formula used is as follows: ='\\Casnrm1cdfile05\sbcis_it_qc\Weekly Status Reports\Project Folders by Lead\Ghafouri\[August Oracle 10G.xls]Weekly Status Report'!$I$9:$K $9 Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling out repeated data in huge spreadsheet | Excel Discussion (Misc queries) | |||
pulling data automatically from one spreadsheet to another | Excel Worksheet Functions | |||
Pulling data from multiple spreadsheet | Excel Worksheet Functions | |||
Exported data pulling into another spreadsheet | Excel Discussion (Misc queries) | |||
Please Help! - Need Help pulling data from one spreadsheet to anot | Excel Worksheet Functions |