Home

Copy sheet to a new workbook produces #N/A error in HLOOKUP function

%3CLINGO-SUB%20id%3D%22lingo-sub-553428%22%20slang%3D%22en-US%22%3ECopy%20sheet%20to%20a%20new%20workbook%20produces%20%23N%2FA%20error%20in%20HLOOKUP%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-553428%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20a%20weird%20bug.%3C%2FP%3E%3CP%3EI%20have%20this%20multiple%20sheet%20workbook%2C%20an%20.xlsm%20file%2C%20with%20many%20VLOOKUP%20and%20HLOOKUP%20functions%20with%20links%20between%20sheets.%3C%2FP%3E%3CP%3EIn%20the%20past%20I%20used%20to%20make%20small%20single%20sheet%20.xlsx%20workbooks%20linked%20to%20the%20original%20by%20just%20duplicating%20a%20desired%20sheet%20to%20a%20new%20workbook.%3C%2FP%3E%3CP%3EHowever%20now%2C%20after%20updating%20to%20vs%2016.16.9%2C%20copying%20a%20sheet%20to%20a%20new%20workbook%20produces%20errors%20in%20an%20HLOOKUP%20formula%2C%20and%20the%20result%20is%20a%20184%20KB%20.xlsx%20workbook.%3C%2FP%3E%3CP%3EHowever%2C%20if%20a%20.xlsx%20workbook%20produced%20before%20this%20last%20update%20is%20%C2%ABsaved%20as%C2%BB%20the%20result%20is%20a%20188%20KB%20file%2C%20and%20the%20HLOOKUP%20function%20works%20fine%20.%20EXCEL%2016.16.9%20(MAC)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-553428%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
pagrest1949
Occasional Visitor

This is a weird bug.

I have this multiple sheet workbook, an .xlsm file, with many VLOOKUP and HLOOKUP functions with links between sheets.

In the past I used to make small single sheet .xlsx workbooks linked to the original by just duplicating a desired sheet to a new workbook.

However now, after updating to vs 16.16.9, copying a sheet to a new workbook produces errors in an HLOOKUP formula, and the result is a 184 KB .xlsx workbook.

However, if a .xlsx workbook produced before this last update is «saved as» the result is a 188 KB file, and the HLOOKUP function works fine . EXCEL 16.16.9 (MAC)

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies