Formulas

Resolved · Low Priority · Version 2003

Tue 7 Oct 2008, 17:12 Delegate Sheila said...

Sheila has attended:
Excel Intermediate course

Formulas

How do you use a formula to calculate figures on one worksheet to adjust figures on another worksheet.

Wed 8 Oct 2008, 12:53 Trainer David said...

RE: Formulas

Hi Shiela, could you provide a little bit more information as to what you would like to achieve and I can try assist you.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Make macros work in newer versions of Excel

If you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using.

To do this, go to Tools - Options - Security.

Select Macro Security and change the security setting to Low.

Tick the boxes next to 'Trust Add-ins' and 'Trust Visual Basic' and click OK.

After you have restarted Windows, you should then be able to use your macros created in earlier versions of Excel.

View all Excel hints and tips