Cant find Project or library error

[excelstudent74]

Greetings

Within the last 6 months i created a spreadsheet that grabs data from an external realtime database. I have several macros in the workbook to refresh data, copy and paste comments etc.
The computer I did all this work on died, and a new computer was issued to me. now when I'm in that work book, I can't refresh (F9) or type text in a cell and hit enter/tab without getting a VBA error box that says Cant find Project or Library. Old computer was running Windows XP and Office 2010. New computer is running Windos 7 64bit with office 2010. I can open and run the workbook on other XP pc's with no issues. but I get these errors on 2 diferent (newer) PCs. Anyone else exeriencing this type of thing? Anyone Know how to fix it...

I should tellyou that I have no MISSING: references in the dialog window.

Thanks

Student74

[Richard Buttrey]

Do you have any references that are needed that are unticked?

[excelstudent74]

I don't know what refrences are needed. I have some autorun commands in "this workbook" section.
Application.OnTime TimeValue("18:00:00"), "Data_Update"

In a module, I have an autorun that refreshes and saves data from external database every 15 minutes.
dTime = Now + TimeSerial(0, 15, 0)
Application.OnTime dTime, "RunOnTime"

lNum = lNum + 1
If lNum = 47 Then
Run "CancelOnTime"
Else
Run "Data_Update"
End If

At certain times during the day the user has to sign into a secure firewall, and so a userform is called up to remind and provide a quick hyperlink.

[Richard Buttrey]

What references do you have ticked?

[excelstudent74]

Visual Basic for Applications
Microsoft Excel 14.0 Object Library
OLE Automaiton
Microsoft Office 14.0 Object Library
Microsoft Forms 2.0 Object Library

I have over 400 additional unchecked references in the box that come up.

[pareshj]

Hi,

Can you attach the workbook which is giving the reference error.


Regards,
Paresh J

[excelstudent74]

I have attached the workbook i have questions about.
Thank you

[romperstomper]

I don't think the issue is with that workbook - I think it's probably a reference error in your AtData.xlam add-in.

[excelstudent74]

When looking at the Atdata.xlam
I removed all files from program files (X86)\microsoft office\office14\library and only replacing the atdata.xlam, and atbatch.xlam. this removed an atIP21config.xlam file. When I re opened the excel file, it told me that it couldn't find the atip21config file, but the workbook works as it should. thinking back I don't remember ever seeing that file before. Thanks for pointing me in the right direction.

Student74