#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Importing etc.

Problem:
1. Excel pension personal file, supplied with linked template
(X per cent per year of service, times peak salary etc.,
and three classes of deduction) presumably made with
up to date Excel software (albeit in another language)
2. My available software is
Quattro v.10 (preferred)
Open Office (Star Office) current version
Office 97 instal disk (software uninstalled 5 or 10 years ago.)

I can read both the template and the data file individually in
either Quattro or OO Calc, but they are not linked normally.
Instructions to link them causes data entries to show 00.0.

What is my best policy?
A = attempt to rewrite both in Quattro (or OO).
B = instal antique version of Excel just in case it can read them.

--
Don Phillipson
Carlsbad Springs
(Ottawa, Canada)



  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default Importing etc.

Excel_97 will be able to read .xls files, so re-installing that should
help you. When you open a file with external links Excel will ask if
you want to update those links - you should answer no, as you don't
have the files on your PC, and Excel will take the values that were
used when the file was saved.

Hope this helps.

Pete

On Jan 17, 9:44*pm, "Don Phillipson" wrote:
Problem:
1. *Excel pension personal file, supplied with linked template
(X per cent per year of service, times peak salary etc.,
and three classes of deduction) presumably made with
up to date Excel software (albeit in another language)
2. *My available software is
* * Quattro v.10 (preferred)
* * Open Office (Star Office) current version
* * Office 97 instal disk (software uninstalled 5 or 10 years ago.)

I can read both the template and the data file individually in
either Quattro or OO Calc, but they are not linked normally.
Instructions to link them causes data entries to show 00.0.

What is my best policy?
A = attempt to rewrite both in Quattro (or OO).
B = instal antique version of Excel just in case it can read them.

--
Don Phillipson
Carlsbad Springs
(Ottawa, Canada)


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing XML Bing New Users to Excel 0 January 12th 09 09:10 PM
Importing Alan Beban's code on Arrays; Importing a module or a project Steve G Excel Worksheet Functions 4 August 27th 07 04:18 PM
importing SDF FC Excel Worksheet Functions 0 September 15th 06 11:47 AM
Importing dan Excel Worksheet Functions 2 August 9th 06 02:32 PM
importing csv Gary''s Student Excel Discussion (Misc queries) 2 November 9th 05 04:41 PM


All times are GMT +1. The time now is 09:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"