Excel Experts Arise!

[Dave5N]

I have a spreadsheet that won't behave and I need help.

Please.

 

[Dave5N]

Pretty please?

 

[MacB]

what's the problem and I'll try, you can e-mail it to me if need be

homosap2001@yahoo.co.uk

 

[WelshYiddo]

Pretty please?

How is it misbehaving?

 

[MacB]

to be fair this is a real toughy, I've never had to guess, as well as solve, the problem before Do I need to start a poll for what the problem might be or is that going OTT?

 

[PpPete]

I thought I knew about Excel, but this one's got me beat.

 

[BigonaBianchi]

I am about to take an exam in Excel..so just dont ask me ok.

 

[Theseus]

Check your macro's. You have inserted/deleted some rows/columns and this has broken the code. I do this all the time.

 

[numbnuts]

If all else fails with Excel use Lotus 1-2-3

 

[rh100]

is it plugged in? (the pc that is)
have you turned it off and on again

 

[rh100]

or buy an abacus

 

[SavageHoutkop]

is it just me or does this thread need an attachment or better description of the bug?

 

[longers]

Check your macro's. You have inserted/deleted some rows/columns and this has broken the code. I do this all the time.

That's why my timesheets spreadsheet plays silly buggers, how do I check the macro's please?

I didn't write the spreadsheet and am thick so please explain gently.

 

[MacB]

That's why my timesheets spreadsheet plays silly buggers, how do I check the macro's please?

I didn't write the spreadsheet and am thick so please explain gently.

Go into the tools button in the menu bar and select macros, you should then be able to view the existing. A macro is just a recording of certain action/s that can be repeated by hitting the run macro option. Check that what the macro does still refers to the correct cells etc, if it doesn't, amend and save again. To create a new macro hit the record macro button, carry out the various actions, then end and save the macro, I also name them. To be honest I rarely use them for everyday stuff as formula can be written so quickly and easily. They only really come into their own if you're churning alrge amounts of data in a repetitive fashion.

 

[longers]

I really am underknowledged about Excel and thought Macro was the fancy name for formulae , thanks though MacB.