#1
|
|||
|
|||
"Circular References," but formatted as text
I have a table, originally an .xls but saved as an .xlsx now that I switched to Excel 2016. All cells have been formatted as text.
When I open it, I get an error message about circular references and formulas--but as far as I can tell, I have no formulas, just words and numerical data. Having to click past the message every time I use the file is a very minor nuisance, but is there some way to get rid of it? |
#2
|
|||
|
|||
Could you possibly upload the file?
|
#3
|
||||
|
||||
On you XL sheet ( usually left lower corner) you have the indication of the cell in which the circular ref occurs. Perhaps that will give a clue?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#4
|
|||
|
|||
That fixed it.
Thanks! That did the job!
The problem was a stray 0 on line 279 of an otherwise empty column. I'm still not sure why that was considered a "formula" rather than just a datum, though. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Updating "Parent Phrase" to change all Child Phrases - (References, Fields, Headings?) | tclass117 | Word | 1 | 11-18-2016 10:14 PM |
Replace "comma" with "and" in line of text | audioman | Word VBA | 7 | 01-21-2016 03:11 PM |
Underlined Purple Text and "formatted" boxes at side of document | SeanCGR | Word | 1 | 06-20-2014 06:49 AM |
Can't find "References" on Word 2013 | Lyn Z. Page | Word | 1 | 05-29-2014 09:57 AM |
Formatting "slipping off" of cross references | Boatwrenchv8 | Word | 6 | 10-16-2012 10:30 AM |