Excel Excell 2007

[gordonb]

I have just upgraded to Excel 2007, under Windows XP

Many of my spreadsheets do not run, and throw up lots of error messages, which were not there in Excel 2003.

For instance an extract from a vb sub

-----------------------------------
Dim Bypass as Integer
...
....
Set ws2 = Worksheets("Design_data")
ByPass = ws2.Range("Y1").Value
If ByPass = 1 Then
Exit Sub
End If
...
...
----------------------------------

gives an error messsage
run-time error '-2147417848(80010108)' Method 'value' of object 'Range' failed



I also receive a compatibility report

Minor loss of fidelity
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.

when there are no links to other workbooks


any suggestions on the 2 issues ?

 

[Anon_F]

Have you checked the Microsoft - Knowledge Base to see what they think?
For more info click HERE