Problem Description Clicking the "Clear Data" or "Open Excel File" button does not execute the macros. When we try to reassign the macros, the Excel file cannot be saved, displaying the following error: Cause of Problem This happens if the "path and the file name" together exceed 218 characters. Solution Shorten the file name or place the file in a folder such that the total length of the path and file name do not exceed 218 characters. INCORRECT: Too long FilePath or FileName C:\Users\X\Documents\very-long-path-to-the-excel-file-which-is-more-than-218-characters-due-to-which-the-macros-assigned-to-buttons-do-not-work-this-is-an-example-of-a-very-long-folder-name\Vouchers-V12-Sales-Purchase-With-Stockitems-Advanced.xls CORRECT: FilePath and FileName are less than 218 characters C:\Users\X\Documents\myfolder\Vouchers-V12-Sales-Purchase-With-Stockitems-Advanced.xls