cancel
Showing results for 
Search instead for 
Did you mean: 

Live Office SP3.4/Office 2010 - Live Office objects disappear on conversion

Former Member
0 Kudos

I am testing Live Office XI 3.1 FP3.4 on a Windows 7 laptop with Office 2010 installed and have a question.

I take an Excel 2003 file (XLS) file that has Live Office connections and open it in Office 2010. Then I save as an XLSX file. While saving I get a message that states:

"The name, [1]_1_CRADDIN_DataGrid, either conflicts with a valid range reference of is invalid for Excel. The name has been replaced with 11__1_CRADDIN_DataGrid. You may still need to manually update any references to this name used in VBA code or as text arguements in functions. You must close and reopen the workbook before these changes take effect."

I complete the save then close and reopen the file. When I go check for my Live Office objects, they seem to have disappeared (meaning I right click on what used to be a Live Office object, but I no longer see Live Office on the popup menu).

Can't I convert my old data models to the new excel format? I am doing this because the XLF is taking a LONG time to open in Xcelsius 2008 SP4 with multiple server busy messages. I thought updating the Excel file might speed things up but since the Live Office objects are disappearing from my spreadsheet this is not working as expected.

If any pointers can be given that would be great. If I have missed any documenation that may help me out, please let me know. I checked the Live Office documentation and the highest thing for XI 3.1 I see is SP3, no FP3.4 (or even SP4).

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi, is your office 32-bit or 64-bit? Note that 2010 64-bit is still not supported.

Also, do you have named ranges in your sheet?

Former Member
0 Kudos

How do I know if Office is 64 bit? If I go to the control panel, I see that "Microsoft Office Professional Plus 2010" is installed.

There are no named ranges in my sheet.

Former Member
0 Kudos

I figuired out how to check the Office 2010 version. It is 32 bit.