Query on how to add Microsoft Office Object library 14.0 on excel

**sethmaceda** · 04-09-2015, 01:45 PM

Hi guys, I have created a macro-enabled workbook in excel version 2010,
and i have to open it to another computer that is lower in version which is excel 2007 ,
and it prompts an error message "Error 91 (Object variable or With block variable not set)"

I have read that there are some compatibility issues of opening excel from newer version to lower versions.

but my excel contains macros which automates grading computation.

Please help ExcelMVPs Thanks a lot!!!

Hope to hear from experts

**pjwhitfield** · 04-09-2015, 01:51 PM

have you tried saving the workbook in 2007 version (or even better try saving it as 97-2000)?

**sethmaceda** · 04-10-2015, 04:35 AM

as far as i know, the effect of saving the workbook in 2007 version or saving it as 97-2000 makes the excel document run in compatibility mode. The problem in compatibility mode is that the columns and rows became limited as compared to the original document, since i have some sheets utilized most number of columns and rows.

I have tried that though, but I would like to run 100% smooth and perfect the .xlsm file of 2010 in lower version of office to 2007

Thank you very much! i would like to get it fix thank you very much!