Too few columns in workbook created in old version of Excel!

I have a massive workbook that contains many tabs and macros. The workbook was created in an older version of Excel and has been duplicated each year for the new year to the point where it is now used in Excel 2007; however, I am still very limited to the number of columns I get, way too few! The workbook is not in capatibilty mode and was saved as an .xlsm file.
I am not given the option to Convert the workbook.
Any ideas on how I can get the additonal columns and rows that go with the Excel 2007 version?

I have Excel 2007 and I'm assuming is what you're referring to is the old cut & paste method?

After writing my initial email laying out everything I've tried and/or looked at, I figured it would be down to this. thank you for the assistance!