LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Circular References, what a nightmare.

Hi

I have an excel spreadsheet which through no fault of my own, and
dictated by business logic alone, forces me to employ circular
references.

I've gone to the lengths of writing data to a file to try and escape
the situation but now sometimes, my xls starts fine, sometimes it
doesnt'.

Sometimes Excel crashes on startup and I have to disable macros.

The funny thing is the spreadsheet works fine aok when I cobble the
sheet back to together with all the circular references. The problem
is it breaks everytime i open it and I'd like to distribute the file
but it's highly annoying to have end users to have to reset fields
with references AFTER they open the file.

Any suggestions any one??? :(
Timothy

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Circular References Alexey[_2_] Excel Worksheet Functions 4 September 24th 08 10:33 AM
Circular References thejamie Excel Discussion (Misc queries) 2 March 16th 08 12:09 PM
Circular references R.Hocking Excel Worksheet Functions 1 February 2nd 06 06:51 PM
Help :Circular References PPT Excel Worksheet Functions 1 January 29th 06 03:20 PM
Circular References Wendy[_3_] Excel Programming 1 July 29th 03 06:24 AM


All times are GMT +1. The time now is 02:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"