Macro recording in Excel

Resolved · Urgent Priority · Version 2007

Fri 24 Jun 2011, 12:23 Delegate Ranyere said...

Ranyere has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Macro recording in Excel

I have a worksheet with data for the last 12 weeks (this data is grabbed from another worksheet within the same workbook) and charts (which references to the data in this worksheet) that I update weekly. I tried to record a macro so data and charts would be updated, however it worked only with the data - no charts were updated.

Do I have to do it differently? Does Macro work for charts as well?

Thank you,
Ranyere

Fri 24 Jun 2011, 13:53 Trainer Stephen said...

RE: Macro recording in Excel

Hi Ranyere

Thanks for your question

This is a little puzzling because the chart should automatically update when the data changes. How do you update the data in the macro? Is it possible for you to send me a copy of the workbook?
If so my email address is sw@stl-training.co.uk

Regards

Stephen

Fri 24 Jun 2011, 14:57 Delegate Ranyere said...

RE: Macro recording in Excel

Hi Stephen,

I've replied to the email given by you with the sheet attached to.

Many thanks,
Ranyere

Mon 27 Jun 2011, 10:55 Trainer Stephen said...

RE: Macro recording in Excel

Hi Ranyere

Thanks for sending me the file. I was looking at it over the weekend and unfortunately had a few problems with my hard drive. As a result, the file you sent has been lost.

Could you resend it to me please

Sorry about this

Cheers

Stephen

Mon 27 Jun 2011, 12:13 Delegate Ranyere said...

RE: Macro recording in Excel

Not a problem at all, Stephen. I've just sent it to you.

Many thanks,
Ranyere

Thu 30 Jun 2011, 10:30 Delegate Ranyere said...

RE: Macro recording in Excel

Hi Stephen,

I was wondering if you've had a chance to have a look at the sheet?

Many thanks,
Ranyere

Thu 30 Jun 2011, 14:36 Trainer Stephen said...

RE: Macro recording in Excel

Hi Ranyere

Sorry for the delay

I've looked at the file you sent me and there is no macro with it. This suggests that when you recorded the macro you stored it in your personal macro workbook. This might effect your problem as the file might not be properly referenced.
Can I suggest you re record the macro, but choose the "Save Macro in this workbook" option. If this solves the problem then great, if not then send me the new workbook, with the macro so I can have a look at the underlying code.

If re recording the macro is too difficult, let me know and I'll give you a procedure for copying it across.

Regards

Stephen

Fri 1 Jul 2011, 09:56 Trainer Stephen said...

RE: Macro recording in Excel

Hi Ranyere

Thanks for the file.

When I run the macro, everything runs fine. In particular all the charts seem to update automatically.

One thing to check is whether you are in automatic calculation mode. Go to the formula ribbon, and in the calculation group click on calculation options and make sure that automatic is selected

Failing that, as the file works on my machine it is difficult for me to do any more without sitting down at your machine. One possibility would be to consult your IT support people as it could be an installation issue

Regards

Stephen

Fri 1 Jul 2011, 12:00 Delegate Ranyere said...

RE: Macro recording in Excel

Hi Stephen,

Thanks for that.

I am in automatic mode.

Note that the table and charts are for the last 12 weeks, What happens here is that when I click on the botton the table is updated fine (it goes from weeks 14-25 to weeks 15-26), however the charts don't follow suit (they go from weeks 14-25 to weeks 15-25) but display 11 weeks only.

Doesn't that happen there?

I'll get the IT team to check my machine.

Thanks,
Ranyere