Linking two spreadsheet, pulling data from one cell to another, data is being truncated

B

Ben

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking data in MS Word into Excel 5
Automatically sending multiple parts of text from one word doc to another - is possible. 0
External cell reference between two excel worksheets both in One Drive 0
Pulling data from one spreadsheet to another. 0
Collate data from one spreadsheet into another spreadsheet 2
Adding data to MS Access from csv file 0
Grouping Names in Mail Merge 0
Create timeline with event being hyperlinks to documents on drive 1

Top