Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #11   Report Post  
Old September 17th 10, 08:32 AM
Banned
 
First recorded activity by ExcelBanter: Sep 2010
Posts: 2
Default

Dear Bret

This is a common Problem in Excel and I know 2 reasons for that:

1) Whenever you integrate Links into formulas (e.g. Sum('C:\[test.xls]Sheet1A1:A10') you need to open the other excel file for an update.

2) You have too many formulas in your excel file.

Sometimes Excel just doesn't calculate although calculation settings are on automatic calculation. The tool below provides you with an extended calculation feature, that fixes that problem:

MTools: Excel Add-In that offers an extended calculation in the case that excel doesn't calculate even in automatic calculation mode

Regards
Marc

Last edited by Marc2010 : September 17th 10 at 08:40 AM

Reply
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
Suppress Update Links Message blatham Excel Discussion (Misc queries) 2 April 20th 06 02:34 PM
Startup prompt - Update links Horatio J. Bilge Excel Discussion (Misc queries) 10 February 15th 06 06:48 AM
Automatically update links when server names change J Hotch Excel Worksheet Functions 1 August 3rd 05 03:50 PM
Edit Links: make update manual Chrissorr Excel Discussion (Misc queries) 5 May 11th 05 11:57 PM
Update Automatic Links Not Working in 2003 cydkil Excel Discussion (Misc queries) 2 February 15th 05 03:35 PM


All times are GMT +1. The time now is 10:40 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017