Excel - Footer Issues

%3CLINGO-SUB%20id%3D%22lingo-sub-1494942%22%20slang%3D%22en-US%22%3EExcel%20-%20Footer%20Issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1494942%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20issues%20with%20my%20footer%20in%20Excel.%20I%20am%20trying%20to%20change%20the%20footer%20information.%20Currently%20my%20footer%20is%20Issue%20%2F%20Version%23%20(Left%20hand%20side)%2C%20Page%20Number%20(Middle)%2C%20Initials_______%20(Right%20hand%20side).%20I%20am%20wanting%20to%20get%20rid%20of%20the%20left%20hand%20side%20info%20(Issue%20%2F%20Version%23).%20I%20delete%20this%20and%20make%20it%20blank%2C%20but%20then%20every%20time%20I%20save%20the%20Excel%20document%20it%20reverts%20back%20to%26nbsp%3BIssue%20%2F%20Version%23%20straight%20away.%20My%20doc%20is%20Marco%20Enable%20and%20I%20was%20wondering%20is%20this%20is%20causing%20this%20issue.%20If%20anyone%20has%20any%20ideas%20please%20let%20me%20know%20.....%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1494942%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1495127%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Footer%20Issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1495127%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F695988%22%20target%3D%22_blank%22%3E%40Sam_evans1340%3C%2FA%3E%26nbsp%3BTo%20detect%20if%20your%20footer%20is%20macro-based%20or%20not%2C%20instead%20of%20deleting%20Issue%2FVersion%20%23%2C%20you%20could%20try%20to%20replace%20all%20of%20your%20footer%20with%2C%20say%2C%20Date%20%26amp%3B%20Time%20on%20Left%20pane%2C%20Filename%20on%20Middle%20and%20Page%20%23%20on%20Right%20(whichever%20icon%20available%20for%20footer)%20then%20save%20your%20document.%20If%20it%20does%20not%20show%20your%20new%20change%2C%20it%20means%20a%20macro%20behind%20the%20scene%20(likely%20triggered%20by%20Before%20Save%20event)%20is%20actually%20generating%20your%20footer%20and%20you%20could%20not%20override%20it%20by%20manually%20editing%20footer.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am having issues with my footer in Excel. I am trying to change the footer information. Currently my footer is Issue / Version# (Left hand side), Page Number (Middle), Initials_______ (Right hand side). I am wanting to get rid of the left hand side info (Issue / Version#). I delete this and make it blank, but then every time I save the Excel document it reverts back to Issue / Version# straight away. My doc is Marco Enable and I was wondering is this is causing this issue. If anyone has any ideas please let me know .....

1 Reply

@Sam_evans1340 To detect if your footer is macro-based or not, instead of deleting Issue/Version #, you could try to replace all of your footer with, say, Date & Time on Left pane, Filename on Middle and Page # on Right (whichever icon available for footer) then save your document. If it does not show your new change, it means a macro behind the scene (likely triggered by Before Save event) is actually generating your footer and you could not override it by manually editing footer.