LraeSinned
New Member
- Joined
- Aug 12, 2008
- Messages
- 47
I developed a spreadsheet app in Excel 2003 and installed this latest version in 11/2008 on an XP machine that has been rebooted many times since then. File date is still 11/2008.
Today, after rebooting/defragging the application will not run. User is getting a compile error (variable not defined) with this line of code:
pt.PivotCache.MissingItemsLimit = [ xlMissingItemsNone ]
The brackets are to indicate this variable is highlighted in the editor.
I am running Excel 2007 and a copy of this works fine on my machine now.
I archive each replaced copy and tried an older version on the target PC (in case someone has been tinkering) and get the same error.
I rebooted again hoping that would clear the problem but it hasn't.
It's like Excel can't use this reference now. Strange.
So the site is not getting their quarterly-hour status updates until I work this out. TIA for any light you can shed on this.
Dennis
Today, after rebooting/defragging the application will not run. User is getting a compile error (variable not defined) with this line of code:
pt.PivotCache.MissingItemsLimit = [ xlMissingItemsNone ]
The brackets are to indicate this variable is highlighted in the editor.
I am running Excel 2007 and a copy of this works fine on my machine now.
I archive each replaced copy and tried an older version on the target PC (in case someone has been tinkering) and get the same error.
I rebooted again hoping that would clear the problem but it hasn't.
It's like Excel can't use this reference now. Strange.
So the site is not getting their quarterly-hour status updates until I work this out. TIA for any light you can shed on this.
Dennis