So my issue is with Sharepoint 2007 and what is happening is that when I output to a excel spread sheet a custom view, If I export some calculated columns it also brings in the columns that were used to calculated that column, even if those columns are not in the current view.
So I tested this like so. I made a view with just 1 column Annualized Savings which is a calculated field =(savings 2012 + savings 2013). Then I simply hit export to spreadsheet, and I get two extra columns Savings 2012 and savings 2013 even though I only had the annualized savings in my view.
I personally have a feeling its because I used a custom Form, but I want to use my custom layout I made in the NewForm, and EditForm.
Thanks in Advance.