Versions to offer

[krm2551]

I have a blog (www.homeskills101.com) on which would like to offer an Excel spreadsheet to my readers. I need to know what versions to offer it in. I have Excel 2010. I understand in 2007 they switched file types. Also, are Excel files automatically able to be opened in OpenOffice for those who do not have Microsoft or do I need to make a version available for that also.

Thanks you, I am self taught and always have lots of questions when I go to do something.

P.S. There are no macros in this particular worksheet so no need to worry about that. BUT for the future if I do make one with macros does that change what versions I need to offer - as in Macro Enabled.

[darknation144]

Open office can open any .xls or .xlsx file. If you want the most people to be able to view it save it as 97-2003 format. That will work with all future versions.

A few functions don't work in older versions but unless your spreadsheet is super complicated you won't have a problem.

[Pete_UK]

If you save the file in 97/2003 compatible format (i.e. with an extension of .xls) then this can be opened directly by all Excel users and also users of OpenOffice. You should avoid using functions which only appeared in XL2007 (COUNTIFS, SUMIFS, AVERAGEIF, IFERROR etc), as well as restricting any conditional formatting to 3 conditions maximum. The colour palette also changed, so you may need to be careful of some combinations which might look a bit garish if opened in XL2003.

Hope this helps.

Pete

[krm2551]

Wow, you guys are fast. Thank you. Well that does bring up a problem then, I do have an IFERROR formula in my worksheet =IFERROR(ROUNDUP(30/F6*$D$2,0),0) Where F6 can sometimes be blank. I use this because the results of this cell are used to calculate another cell.

[Pete_UK]

Well, you can get round it in a number of ways. Here's a couple:

=IF(F6=0,0,ROUNDUP(30/F6*$D$2,0)

=IF(ISERROR(ROUNDUP(30/F6*$D$2,0)),0,ROUNDUP(30/F6*$D$2,0))

Hope this helps.

Pete

[krm2551]

Thanks, that does help. You guys are great.