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 ?
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 ?