Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ben Ben is offline
external usenet poster
 
Posts: 5
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pulling out repeated data in huge spreadsheet cklevine Excel Discussion (Misc queries) 10 September 12th 07 02:33 PM
pulling data automatically from one spreadsheet to another [email protected] Excel Worksheet Functions 2 April 7th 07 04:30 AM
Pulling data from multiple spreadsheet Mark C[_2_] Excel Worksheet Functions 2 February 27th 07 05:02 AM
Exported data pulling into another spreadsheet Bemidji Excel Discussion (Misc queries) 6 August 8th 06 03:58 PM
Please Help! - Need Help pulling data from one spreadsheet to anot dhwinters Excel Worksheet Functions 1 February 1st 06 10:20 PM


All times are GMT +1. The time now is 08:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"