News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

Unexpected 310 error for a circular formula reference

Started by Hey Ken, December 09, 2019, 05:17:56 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Hey Ken

Fellow Wizards:

   I have a problem. 

   Attached is a very simple stencil.  Open a blank document, open the stencil, and manually drop the box onto the blank page.  My 2013 professional throws a 310 error for a circular formula reference when there are no circular formulas.  Go figure.  Does it happen to anyone else?  If so, can you figure out how to fix it?

   Thanks in advance,
   
   - Ken




Ken V. Krawchuk
Author
No Dogs on Mars - A Starship Story
http://astarshipstory.com

Croc

I think the thing is User-defined Cells of the Stencil.
If you delete the rows:
User.Font
User.FontSize
User.Locked
then the error will disappear

Hey Ken


   Well, look at that!  Never thought to check the stencil's document sheet.  It turns out those fields are all from a completely different project.  Apparently somewhere in some poorly-tested VBA code, ActiveDocument wasn't the active document I wanted.  Thanks, Croc!

   - Ken
Ken V. Krawchuk
Author
No Dogs on Mars - A Starship Story
http://astarshipstory.com

Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 187 (show)
Files included: 38 - 1676KB. (show)
Memory used: 1260KB.
Tokens: post-login.
Cache hits: 15: 0.00378s for 26,742 bytes (show)
Cache misses: 5: (show)
Queries used: 16.

[Show Queries]