Excel 97 - Windows 7

[User]

 

[gaz]

Why not get open office for free? does everything office does, but for nothing.

 

[vernon]

Why not get open office for free? does everything office does, but for nothing.

The VBA scripting mentioned by the original poster will be a problem when migrating from Excel to OpenOffice.

Microsoft have a compatibility spreadsheet listing over 5,000 applications that have been tested against Windows 7.

A paid update is required for Office97 according to the spreadsheet.

I am not sure about how portable your spreadsheets will be when migrating onto Office 2007 as I have no direct experience of VBA rich spreadsheets.

 

[CopperBrompton]

I understand the Office97 / Excel 97 will not work on Windows 7, is this correct?

I would be surprised if that were the case. If nothing else, it should run in XP virtualisation mode.

 

[ian turner]

Let us imagine you manage to get it to run on 7.
This is delaying the inevitable.
It may be a lot of work to transfer to a new spreadsheet and replace the VBA scripts
but it won't get any less by waiting unless you get killed by a careless motorist.
Windows 98 had problems years ago with faster processors and clock speeds being too
high for its liking. XP will be dead when a new disk drive interface or suchlike appears and
no one writes any drivers for it.

 

[gaz]

didn't see the stuff about VBA, my bad.

 

[Jezston]

Gaz - I feel I should also let you know that my experience of OpenOffice Calc, I think it was from OpenOffice 3 (and appeared to be unchanged from OpenOffice Calc v1), is that Calc is dangerously unreliable. It would often create random and often very basic calculation errors (e.g, copy drawing a load of increasing numbers - 1,2,3,4,5,7,8,9 ... wait where the **** is 6?) that I would have to get my colleague running the ancient but solid Excel 97 to fix stuff for me!

And this was just a reference table. Imagine doing anything involving money on something that thinks 2+2=5!

 

[dellzeqq]

reiver - why not e-mail an Excel 97 spreadsheet to an Office 2007 user and see how it goes? Or download Office 2007 on a month's trial and see how it goes?

For what it's worth I have both Office 2007 and Open Office 3.2 and only use Office 2007 - although it pains me to admit it

 

[rsvdaz]

have you someone at school in your household?

http://www.software4students.co.uk/Microsoft_Office_2010_Professional_Plus-details.aspx?gclid=CNbIoYvJ-KMCFZFe4wodLRGbIw

 

[jay clock]

have you someone at school in your household?

my thoughts entirely. For under £40 it represents a small proportion of the purchase price of the new PC.

 

[CopperBrompton]

That licence prohibits use for commercial work, however.

 

[Danny]

I have no wish or desire to buy office 2007, complete waste of money since excel 97 does everything that I need.

While I am not a big defender of Microsoft's upgrade strategy, I do think it is time you considered moving to a newer version of MS Office.

Office 97 is now 13 years old and you can't expect Microsoft to maintain backward compatibility forever. I can understand your reluctance to move to a newer version if you have got 10,000 lines of VBA script, but if you put it off you may find it even more difficult to move in the future.

As a matter of interest what on earth are your 10,000 lines of script doing? It seems a phenomenal amount of coding to build into an Excel workbook.

 

[ASC1951]

have you someone at school in your household?

http://www.software4...CFZFe4wodLRGbIw

Does that actually work? The site suggests that the school has to be already signed up to some MS scheme and commit itself to minimum annual purchase.

Or is that just flannel and in reality any student can access the deal?

 

[PaulSB]

Or download Office 2007 on a month's trial and see how it goes?

I could be wrong but from what I recall we tried this at work about 3 years ago and found we couldn't revert back to the Office 2000 we already had installed. Ended up having to buy 2007 to solve the issue. If you try this I would create a restore point and be ready to restore after you've played around but not done any serious work in other programmes.

 

[jay clock]

Does that actually work? The site suggests that the school has to be already signed up to some MS scheme and commit itself to minimum annual purchase.

Or is that just flannel and in reality any student can access the deal?

pretty much anyone can get it. I have two stepkids at school and three of my own at uni, so no problem at all