I am having a problem when i try to open an .xlt excel file.
In Windows2000 with Excel 2000 when I double click on the xlt file to open it I am given the Macros prompt and I click on "Enable Macros" (I've tried clicking "Disable Macros" but still have the same results). Then I am receving the message: "An error occurred initializing the VBA libraries (265)".
I click ok on the message and then the Excel application stays open but the Excel file does not open. If i open the Visual Basic Editor from inside Excel and then try to open the file I receive a "Device I/O" error message.
In WindowsXP with Excel 2002 I eventually receive a message box saying:
"Errors were detected in 'filename.xlt', but Microsoft Excel was able to open the file by making the repairs listed below. Save the file to make these repairs permanent. Lost Visual Basic project. Lost ActiveX controls."
When I click Ok the template opens but there is no data in it as there should be. There is just the header and column headings.
When I then save the file, the file size is goes to 33K instead of the 125K it started at originally.
I've found some articles on Microsoft.com that deal with similar issues but in Excel97 and when I've tried their fixes I still end up with the save problem.
I've tried opening other xlt files that contain macros as well and they work find. Any ideas of things I can try to get this file opening properly? Thanks!