Excel applications, working for everybody?

cozzagiorgi

New Member
Joined
Jun 27, 2018
Messages
41
Hi

If you write an excel application that will be distributed to a high number of people. You dont know what excel version they use etc.

How do you go to be sure the application will work for the highest possible number of people?
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Try saving is as a xls (Excel 97-2003), the compatibility checker will tell you if the outmoded format can handle your design :)
 
Upvote 0
That will tell you if it's a problem. You can send it out as an xlsx and a version of Office XP with all the service packs will open it, but test saving it as xls will flag up the potential of functions not working, i.e. the design has formulas which won't funtion in Office XP therefore you can anticipate this as a problem and review your used formula list. ;)
 
Upvote 0
Macros are backwards compatible, so if it ran on Office XP is should (not definitely) run on a bang up to the second version of Excel 365 Insider...

I found this for you, which has in the first reply from Calvin Gao two links, one for testing backward compatibility and the second for an addin to inspect your VBA

https://social.msdn.microsoft.com/F...bility-of-vba-code-in-excel-2010?forum=isvvba

I hope this is useful :)
 
Upvote 0
Macros are backwards compatible, so if it ran on Office XP is should (not definitely) run on a bang up to the second version of Excel 365 Insider...

Not an entirely correct answer as Filesearch for instance was discontinued from 2007 onwards.
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,175
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top