Excel 2007 not picking up Calculations as part of table

eoinymc

Board Regular
Joined
Jan 29, 2009
Messages
203
Hi,

I have a question that is tough to explain, but I'll try my best.

I have a sheet called "Data" & this is a SQL query that I pull using VBA (Rows A:J). I then do some calculations in VBA in Row K (Change from € to $).

When I run this macro, my Excel 2007 doesn't show column K as part of the table (i.e. the column is white and doesn't take the format of the table).

However, when a colleague of mine runs the macro, column K formats as part of the table...

I need it to be part of the table because I do some autofiltering on it in another macro and because column K is not part of the table, it won't let me autofilter the specified range.

It was working just fine for me until Friday and it just seemed to change!!

Does anyone know any settings or reasons this may happen?

It is quite annoying!

If you need any more information, please let me know.

Regards,

Eoin
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

sahild05

New Member
Joined
May 2, 2011
Messages
13
try creating a column k before running the macro by typing in a dummy value for the first row and then clearing it. perhaps the macro is sidestepping the auto-column-detect feature?
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Possibly, look under Excel Options|Proofing|AutoCorrect Options and make sure that 'Include new rows and columns in table' is checked on the 'AutoFormat As You Type' tab.
 

eoinymc

Board Regular
Joined
Jan 29, 2009
Messages
203
Andrew, you really are an MVP!

Thanks for the help..strange that it was working last week and I didn't touch this option and it stopped working!

Anyway, thanks for the help!

Eoin
 

Watch MrExcel Video

Forum statistics

Threads
1,098,992
Messages
5,465,867
Members
406,452
Latest member
GroupGoal

This Week's Hot Topics

Top