Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-12-2016, 12:36 PM
newmaven newmaven is offline "Circular References," but formatted as text Windows 10 "Circular References," but formatted as text Office 2016
Novice
"Circular References," but formatted as text
 
Join Date: Dec 2016
Posts: 19
newmaven is on a distinguished road
Default "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?
Reply With Quote
  #2  
Old 12-12-2016, 11:23 PM
xor xor is offline "Circular References," but formatted as text Windows 10 "Circular References," but formatted as text Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Could you possibly upload the file?
Reply With Quote
  #3  
Old 12-13-2016, 12:59 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline "Circular References," but formatted as text Windows 7 64bit "Circular References," but formatted as text Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

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?
__________________
Using O365 v2503 - 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
Reply With Quote
  #4  
Old 12-13-2016, 02:23 PM
newmaven newmaven is offline "Circular References," but formatted as text Windows 10 "Circular References," but formatted as text Office 2016
Novice
"Circular References," but formatted as text
 
Join Date: Dec 2016
Posts: 19
newmaven is on a distinguished road
Default 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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
"Circular References," but formatted as text 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
"Circular References," but formatted as text Underlined Purple Text and "formatted" boxes at side of document SeanCGR Word 1 06-20-2014 06:49 AM
"Circular References," but formatted as text 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:56 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft