Linked Spreadsheets & Workbooks from Excel 97 & 2000

Discuss the spreadsheet application

Linked Spreadsheets & Workbooks from Excel 97 & 2000

Postby KLund1 » Wed Apr 16, 2008 2:10 am

We are new to Calc. We have hundreds of linked Excel 97 and Excel 2000 spreadsheet files. In Excel, when you open one of these linked spreasheets files, it asks it you want to update the links to the other spreadsheet files. Calc is not asking to update these links when we open a Excel file. Can it do that? If so, what menu, where? We seem to have to updated the link manually one link file at a time. Some spreadsheets are linked to 30 other spreadsheets.
We can not convert to Calc file format, several hundred people are still using Excel, while about 50 now have to use Calc.
Also, in the open file box, Calc will display the icons for Excel files only, not the Excel workbook files ending .xlw. It only shows the unassociated windows file icon. When clicked, Calc displays an error message about unknown file type. We running Windows NT, 2000, & XP computers.
I have searched these forums for threads about this and came up with over 2500 threads, too much to read through. Also Google did not find much help. So we though we'd post here for some specific help.
Thanks in advance for your assistance.
Posts: 14
Joined: Wed Apr 16, 2008 1:46 am

Re: Linked Spreadsheets & Workbooks from Excel 97 & 2000

Postby Villeroy » Wed Apr 16, 2008 5:45 am

Just like in Excel there is a global setting
Menu:Tools>Options...Calc>General:"Update links on open" [always | never | ask]
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Posts: 28650
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Return to Calc

Who is online

Users browsing this forum: No registered users and 24 guests