I'm running into an odd problem with Excel. I have a workbook that gets external data from a text file and puts it in column A of the "Raw Data" tab. I then use the following in another sheet to read the data line by line:
=IF(LEFT(INDIRECT("'Raw Data'!$A"&ROW()),4)="Name",1,0)
This works great until I close the workbook. When I close and reopen it, I get the #VALUE! error everywhere I use the INDIRECT function. If I put my cursor in the function bar and click out of it, all the INDIRECTs suddenly fix themselves. I'm building this for a client and would rather not explain the t they have to do this fix every time they open the file. Any guesses?
Thanks in advance.
Bookmarks