Author Topic: Unexpected 310 error for a circular formula reference  (Read 3937 times)

0 Members and 1 Guest are viewing this topic.

Hey Ken

  • Full Member
  • ***
  • Posts: 233
  • Just This Guy
    • The Pennsylvania Project, with Ken Krawchuk
Unexpected 310 error for a circular formula reference
« on: December 09, 2019, 12:17:56 PM »
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

  • Sr. Member
  • ****
  • Posts: 343
    • Visioport
Re: Unexpected 310 error for a circular formula reference
« Reply #1 on: December 09, 2019, 01:48:44 PM »
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
« Last Edit: December 09, 2019, 01:55:34 PM by Croc »

Hey Ken

  • Full Member
  • ***
  • Posts: 233
  • Just This Guy
    • The Pennsylvania Project, with Ken Krawchuk
Re: Unexpected 310 error for a circular formula reference
« Reply #2 on: December 10, 2019, 09:14:19 AM »

   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