Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default character limit for linking files

Is there a limit to the number of characters that can be linked from one file
to another? Currently, it truncates the data. Please advise.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default character limit for linking files

If you open the sending workbook, then you'll see that the formula returns the
whole string.

With the sending workbook closed, you'll only see 255 characters.

I don't know any other way around it.

Guruwanabe wrote:

Is there a limit to the number of characters that can be linked from one file
to another? Currently, it truncates the data. Please advise.


--

Dave Peterson
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
255 Character Limit Colin Excel Discussion (Misc queries) 2 March 2nd 06 07:58 PM
COUNTIF not counting properly!! Character limit? kytihu Excel Worksheet Functions 2 January 30th 06 04:45 PM
character limit in hyperlink function Brad B. Excel Worksheet Functions 0 December 22nd 05 11:04 PM
How can I change 255 character limit in 'hyperlink' function? Brad B. Excel Worksheet Functions 0 December 21st 05 09:03 PM
Cannot access read-only documents. tomgillane Excel Discussion (Misc queries) 14 February 7th 05 10:53 PM


All times are GMT +1. The time now is 02:50 AM.

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

About Us

"It's about Microsoft Excel"