Solving Cases When Excel Reference Is Not Valid

Asked By NAEEM ZAHRA 0 points N/A Posted on - 07/05/2016

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?

• Status: Open
• Question Views: 407
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Dobik Triko 0 points N/A #127204

Solving Cases When Excel Reference Is Not Valid

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

About Dobik Triko

Questions
27

Answers
11

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/05/2016
• Question Category: MS Excel