Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 407
Default Table

In this file sent to me, I eliminated the obvious circular references
necessitating iterative solutions. I still note that, when I hit recalc, at
the bottom left it goes through "Table: 1" through "Table 9". If I have
only this file open, it does it in a second or so, and then says ready.

If I have another file open, one which is just a normal file, then it take a
long time (probably because the other file is so big), like one minute, to
go through Table 1 through Table 9. But, also when it seems to be done, the
bottom says "recalculate". It seems that, if I have another file open, it
can't recalc this Table stuff.

Does anyone know what this "Table: 1" type stuff is (is it some sort of data
table that, somehow, still requires manual recalc maybe?) and also why it
seems to NOT recalc if another benign file is open?

Thanks!
Dean


 
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
Pivit table- cell on spread sheet referencing pivot table field David M Charts and Charting in Excel 2 August 18th 07 07:46 PM
entry removed from source table remains in pivot table pull down EL in Melb. Excel Worksheet Functions 1 September 6th 06 07:59 AM
PIVOT TABLE - Summary Table into a Databasae Table. sansk_23 Excel Worksheet Functions 4 May 9th 05 07:45 AM
VBA Code for a pivot table to open database and to reference table current page Pete Straman Straman via OfficeKB.com Excel Programming 0 February 21st 05 03:57 AM
create a source table from a special pasted value dynamic crossed table Tom Ogilvy Excel Programming 0 September 29th 03 08:59 PM


All times are GMT +1. The time now is 01:11 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"