Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 30
Default Excel 2007 Compatability Checker

I have a number of files which were created in Excel 2003 (and have only been
modified in Excel 2003).

I have now switched to Excel 2007 and when I am saving I am gettin a number
of fidelity issues arising from the compatability checker.

As I have not modified the files in Excel 2007 I know that I am not using
functionality that is not supported by 2003, so I am wondering if either:

a. It is OK to ignore the compatibility issues that it is raising
or
b. If it means that the spreadsheets were never working correctly in 2003
and it is only now being picked up by the compatability checker.

An example of the messages that I am receiving is:

"Some formulas in this workbook are linked to other workbooks that are
closed. When these formulas are recalculated in earlier versions of Excel
without opening the linked workbooks, characters beyond the 255-character
limit cannot be returned."

I had thought that these were linking fine in 2003 when I was using it - but
am now wondering if they were not previously working, or if this message is
just flagging up that there MIGHT be an issue IF any of the cells go over
this length.

Any ideas/explanations would be welcomed!

Thanks.

Liz.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 143
Default Excel 2007 Compatability Checker

its tru Excel 2003 linking formula canot get texts more that 255 long in
other closed workbook. this is limit of that version but sence you say you
have no link problem then you must not have any these. if you did have some
then they getting cut off

"BoRed79" wrote in message
...
|I have a number of files which were created in Excel 2003 (and have only
been
| modified in Excel 2003).
|
| I have now switched to Excel 2007 and when I am saving I am gettin a
number
| of fidelity issues arising from the compatability checker.
|
| As I have not modified the files in Excel 2007 I know that I am not using
| functionality that is not supported by 2003, so I am wondering if either:
|
| a. It is OK to ignore the compatibility issues that it is raising
| or
| b. If it means that the spreadsheets were never working correctly in 2003
| and it is only now being picked up by the compatability checker.
|
| An example of the messages that I am receiving is:
|
| "Some formulas in this workbook are linked to other workbooks that are
| closed. When these formulas are recalculated in earlier versions of Excel
| without opening the linked workbooks, characters beyond the 255-character
| limit cannot be returned."
|
| I had thought that these were linking fine in 2003 when I was using it -
but
| am now wondering if they were not previously working, or if this message
is
| just flagging up that there MIGHT be an issue IF any of the cells go over
| this length.
|
| Any ideas/explanations would be welcomed!
|
| Thanks.
|
| Liz.

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
Excel 2007 - Compatibility Checker Barb Reinhardt Excel Discussion (Misc queries) 3 May 12th 09 02:06 AM
Compatability Checker .xlsx workbooks Philip J Smith Excel Discussion (Misc queries) 0 April 1st 08 05:31 PM
Excel 07 compatability checker Dave F[_2_] Excel Discussion (Misc queries) 0 February 21st 08 01:54 PM
Excel 2007 Compatability Checker Angie Excel Discussion (Misc queries) 1 January 8th 08 07:48 PM
Compatability checker DDC Excel Discussion (Misc queries) 0 September 12th 07 02:20 AM


All times are GMT +1. The time now is 05:53 PM.

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"