Home

Compatibility issues with .xlsm file made in Excel before 2007

%3CLINGO-SUB%20id%3D%22lingo-sub-644093%22%20slang%3D%22en-US%22%3ECompatibility%20issues%20with%20.xlsm%20file%20made%20in%20Excel%20before%202007%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-644093%22%20slang%3D%22en-US%22%3E%3CP%3EOne%20or%20more%20functions%20in%20this%20workbook%20are%20not%20available%20in%20versions%20prior%20to%20Excel%202007.%20When%20recalculated%20in%20earlier%20versions%2C%20these%20functions%20will%20return%20a%20%23NAME%3F%20error%20instead%20of%20their%20current%20results.%3C%2FP%3E%3CP%3ECurrent%20Excel%20is%202016.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%3F%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EJose%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-644093%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%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-644261%22%20slang%3D%22en-US%22%3ERe%3A%20Compatibility%20issues%20with%20.xlsm%20file%20made%20in%20Excel%20before%202007%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-644261%22%20slang%3D%22en-US%22%3EAre%20you%20perhaps%20using%20the%20wrong%20file%20format%20to%20save%20to%3F%20Like%20%22Excel%2097-2003%20workbook%20(*.xls)%22%3F%3C%2FLINGO-BODY%3E
Jose_Valerio
Occasional Visitor

One or more functions in this workbook are not available in versions prior to Excel 2007. When recalculated in earlier versions, these functions will return a #NAME? error instead of their current results.

Current Excel is 2016.

 

Any ideas?

Thanks

Jose

1 Reply
Are you perhaps using the wrong file format to save to? Like "Excel 97-2003 workbook (*.xls)"?
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies