question

JEOPALENCIA-3899 avatar image
0 Votes"
JEOPALENCIA-3899 asked erinding-msft commented

WHY AM I GETTING THIS ERROR REFERENCE ISN'T VALID IN EXCEL SPREADSHEET

Microsoft Visual Basic Run-time error '-2147024809 (80070057)': Reference isn't valid.

office-vba-devoffice-excel-itpro
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Adding right tags/teams to assist

0 Votes 0 ·

@JEOPALENCIA-3899
Please check TvanStiphout's reply.
Any updates, please let us know.

0 Votes 0 ·

1 Answer

TvanStiphout avatar image
0 Votes"
TvanStiphout answered

Alt+F11 to open the VBA editor.
Tools > References
Check for references listed as Broken. That means that such file is not on this machine.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.