2010 macro problem

[beckster68]

I export a query report from Access to excel daily. It is a pretty simple report it just has to be formatted correctly as it is then loaded into an Oracle upload. The macro works fine on my pc at work. The macro worked fine on the pc of a coworker who sometimes helps me. It worked for my coworker yesterday but not today. The macro selects a column then copies it into the adjacent column and makes the value a negative number. (This is for financial refunds). Anyway, today rather than doing an autofill of the adjacent column it only copied the value from F2 then filled in the entire column with that value.

I had the coworker send me her macro file, I generated the same file from Access and it ran fine. I had her generate another file on her computer from Access and send it to me it ran correctly on my computer with her macro. I did a document compare between my macro and hers and it is exactly the same. I finally sent her my macro and she got the same bad results on her computer.

We also run a similiar report for check refunds and that too did not run correctly on her computer, a unique invoice number, that too only formatted the top row of that column then autofilled the rest with just that one number.

The macros run just not correctly. I can not figure out what would cause this. I have done the F8 step by step on both computers and it is the autofill. Thanks for any help.

Also we are both using xp & office 2010

 

[JoeMo]

Is the autofill step using a custom list to do the fill? If so, the list may not be on your coworker's computer.

 

[beckster68]

Thanks

She also told me none of her workbooks were doing vlookups etc.
Turns out she had a really old workbook open at the sametime that was set to manual calculation. So I changed it to automatic calculation. Everything works fine now.

Until I googled it; I had no idea you could set a sheet to manual calculation. I always thought that is what a spreadsheet is for. You put the formula in and presto changeo it does it job.

I guess maybe if you are doing deep crazy formulas you may want to check...I just want the thing to run and format a report.

Thanks again