Sometimes while working in Microsoft excel there might come instances where a message the excel reference is not valid. What is the reason of this problem and how can it be solved?
This error is most likely when opening an Excel workbook that contains square brackets in the name example “tool[1]”.The reason for the error is that the square brackets being used becomes invalid characters in an Excel workbook file name. This is a very small error with a simple resolution method which is to remove all invalid Excel characters from the file name. Taking care not to include so named characters will surely be helpful
