Excel - Strange calculation issues
Asked By PhilipTric
16-Apr-07 01:38 PM
Occasionally my coworkers and I encounter an issue where after making a
change to fairly large spreadsheets, we'll do a recalc (CTRL+ALT+F9 calc) and
nothing will recalc. We frequently have to do a Find and Replace "=" with "="
in order to get the calculations to update.
We typically turn the Excel calculation to manual due to the size of our
spreadsheets and rely upon CTRL+ALT+F9 or SHIFT+F9 (for a specific sheet) to
calculate when necessary, but in some cases calculations stop occurring until
we close Excel and completely reopen it (or use the Find and Replace method
mentioned above). CTRL+SHIFT+ALT+F9 locks Excel up when this occurs, with a
never ending "0% Calculated" until Excel bombs with an application error.
Any suggestions?
--
Philip Trick
Actuarial Consultant
PP replied...
I am having similar problems with a Circular Reference which only occurs when
I copy a sheet to a new sheet. If I save the workbook under a new name the
calculation takes place without any problem. I'm still using Excel 97, so
maybe this has been fixed in later updates. I'm unable to get any window in
which to post this question, maybe you can help me with that too. When I
click on "New" & "Question" nothing happpens! Any help would be greatly
appreciated.
--
ExcelGiantUser
mailTo hyperlinks in Excel? Excel Excel creates bogus "mailTo" hyperlinks on entering some simple cell formulas like @sum. I know how to remove individual hyperlinks. Is there a way to prevent this silly behavior. Thanks. Excel Miscellaneous Discussions Excel (1) Don't use @sum() Try using = sum() - - Dave Peterson keywords: mailTo, hyperlinks, in Excel? description: Excel creates bogus mailTo hyperlinks on entering some simple cell formulas like @sum. I know how
VBA2D Array Excel Excel , Excel" / > Quick syntax question: is there a way to copy one colunn of a 2D array into excel directly and vice versa? I.e. I have a 200*10VBA array, and I want to plug the value of the 7th column into one Excel Column. Of course I don't want to enter values in Excel one by one. For the moment I fill an intermediary VBA Array of 200*1 expect to be able to do things a bit more directly. Any idea? Thanks Charles Excel Discussions Array (1) Excel (1) Syntax (1) Question (1) Colunn (1) Directly (1) Versa (1) Value (1) Charles wrote
how do i insert a chart from excel? Excel Excel Charting Discussions PowerPoint (1) Excel (1) Workbooks (1) Windows (1) @ says. . . Copy. Paste. - - Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions How do I insert a chart in Excel? or How do I insert an Excel chart into another program? To copy a chart between two excel work book 1. On the Windows menu, click Compare side by side All Workbooks are
Have you tried my suggestion from your post in "microsoft.public.excel.excel"? Excel Have you tried my suggestion from your post in table to get the correct aggregation of XL you are on as pivot tables changed substantially in XL2002. . . - - HTH. . . Jim Thomlinson Excel Programming Discussions XL (1) WOS (1) HTH (1) Excel (1) Microsoft (1) Instructions (1) Aggregation (1) Calculation (1) keywords: Have, you, tried, my, suggestion from, your, post, in, "microsoft.public.excel.excel"? description: Have you tried my suggestion from your post in microsoft.public.excel.excel You need to calculate the WOS in the pivot table to get the correct
How do I sort alphabetically in Excel Excel Excel Miscellaneous Discussions Alphabetically (1) Excel (1) Hello, seh60025! You wrote on Thu, 26 Oct 2006 14:18:01 -0700: Use obvious alterations: not.jim.silverton.at.comcast.not keywords: How, do, I, sort, alphabetically, in, Excel