Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Spreadsheet Calculation Speed and Network Activity
Hi everyone,
I've got a bit of a strange one here, I'm still investigating but thought I might post in case anyone has any ideas. We have a quite complex spreadsheet (Excel 2003) where the speed of calculations had started to become an issue. Upon investigation of the speed issues it became apparent that most of the time, when performing the calculation operaton (either automatically or by pressing F9) a network spike would show in the LAN section of the 'Networking' tab in Task Manager. This spike appears only when calculating and drops back down to 0% as soon as the calculation is complete. This spreadsheet is running completely locally (C drive). There are no links to spreadsheets anywhere on the network. We found that if you unplug the network cable, then the calculation speed is only a fraction of the time, and obviously there is no network activity showing in the task manager. To add further confusion to the problem, it does not appear to happen every time. There are times (so far they seem random, but I'm still looking for a pattern), where you open the spreadsheet and calculation is fast, and no network activity is present. Due to the fact that this activity perfectly coincides with the calculation, I don't believe this has anything to do with any software updates from other applications. Any help/ideas/advice would be welcomed. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Spreadsheet Calculation Speed and Network Activity
Does the spreadsheet contain any Hyperlinks, DDE links, OLE links or any
other kind of link? Is there any VBA used? Charles ______________________ Decision Models FastExcel 2.3 now available Name Manager 4.0 now available www.DecisionModels.com "Steve Telford" wrote in message ... Hi everyone, I've got a bit of a strange one here, I'm still investigating but thought I might post in case anyone has any ideas. We have a quite complex spreadsheet (Excel 2003) where the speed of calculations had started to become an issue. Upon investigation of the speed issues it became apparent that most of the time, when performing the calculation operaton (either automatically or by pressing F9) a network spike would show in the LAN section of the 'Networking' tab in Task Manager. This spike appears only when calculating and drops back down to 0% as soon as the calculation is complete. This spreadsheet is running completely locally (C drive). There are no links to spreadsheets anywhere on the network. We found that if you unplug the network cable, then the calculation speed is only a fraction of the time, and obviously there is no network activity showing in the task manager. To add further confusion to the problem, it does not appear to happen every time. There are times (so far they seem random, but I'm still looking for a pattern), where you open the spreadsheet and calculation is fast, and no network activity is present. Due to the fact that this activity perfectly coincides with the calculation, I don't believe this has anything to do with any software updates from other applications. Any help/ideas/advice would be welcomed. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Spreadsheet Calculation Speed and Network Activity
Thanks for the reply Charles.
The only hyperlinks within the spreadsheet are internal links (links to other worksheets within the same file). There are no DDE links, OLE links or any other data access links. There is a considerable amount of VBA, all of which I have written myself. None of which I would expect to be utilising the network. Is there something I need to look for here or that you may have had in mind? Thanks. Steve "Charles Williams" wrote: Does the spreadsheet contain any Hyperlinks, DDE links, OLE links or any other kind of link? Is there any VBA used? Charles ______________________ Decision Models FastExcel 2.3 now available Name Manager 4.0 now available www.DecisionModels.com "Steve Telford" wrote in message ... Hi everyone, I've got a bit of a strange one here, I'm still investigating but thought I might post in case anyone has any ideas. We have a quite complex spreadsheet (Excel 2003) where the speed of calculations had started to become an issue. Upon investigation of the speed issues it became apparent that most of the time, when performing the calculation operaton (either automatically or by pressing F9) a network spike would show in the LAN section of the 'Networking' tab in Task Manager. This spike appears only when calculating and drops back down to 0% as soon as the calculation is complete. This spreadsheet is running completely locally (C drive). There are no links to spreadsheets anywhere on the network. We found that if you unplug the network cable, then the calculation speed is only a fraction of the time, and obviously there is no network activity showing in the task manager. To add further confusion to the problem, it does not appear to happen every time. There are times (so far they seem random, but I'm still looking for a pattern), where you open the spreadsheet and calculation is fast, and no network activity is present. Due to the fact that this activity perfectly coincides with the calculation, I don't believe this has anything to do with any software updates from other applications. Any help/ideas/advice would be welcomed. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Spreadsheet Calculation Speed and Network Activity
1. Check the References for the VBA project(s) that they dont refer to
anything on the network. 2. try getting rid of the internal hyperlinks and see if that solves the problem Charles ______________________ Decision Models FastExcel 2.3 now available Name Manager 4.0 now available www.DecisionModels.com "Steve T" wrote in message ... Thanks for the reply Charles. The only hyperlinks within the spreadsheet are internal links (links to other worksheets within the same file). There are no DDE links, OLE links or any other data access links. There is a considerable amount of VBA, all of which I have written myself. None of which I would expect to be utilising the network. Is there something I need to look for here or that you may have had in mind? Thanks. Steve "Charles Williams" wrote: Does the spreadsheet contain any Hyperlinks, DDE links, OLE links or any other kind of link? Is there any VBA used? Charles ______________________ Decision Models FastExcel 2.3 now available Name Manager 4.0 now available www.DecisionModels.com "Steve Telford" wrote in message ... Hi everyone, I've got a bit of a strange one here, I'm still investigating but thought I might post in case anyone has any ideas. We have a quite complex spreadsheet (Excel 2003) where the speed of calculations had started to become an issue. Upon investigation of the speed issues it became apparent that most of the time, when performing the calculation operaton (either automatically or by pressing F9) a network spike would show in the LAN section of the 'Networking' tab in Task Manager. This spike appears only when calculating and drops back down to 0% as soon as the calculation is complete. This spreadsheet is running completely locally (C drive). There are no links to spreadsheets anywhere on the network. We found that if you unplug the network cable, then the calculation speed is only a fraction of the time, and obviously there is no network activity showing in the task manager. To add further confusion to the problem, it does not appear to happen every time. There are times (so far they seem random, but I'm still looking for a pattern), where you open the spreadsheet and calculation is fast, and no network activity is present. Due to the fact that this activity perfectly coincides with the calculation, I don't believe this has anything to do with any software updates from other applications. Any help/ideas/advice would be welcomed. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Spreadsheet Calculation Speed and Network Activity
Thanks for the suggestions Charles.
I'm out of the office for a couple of days. I'll give it a shot when I get back and let you know how it goes. Cheers, Steve "Charles Williams" wrote: 1. Check the References for the VBA project(s) that they dont refer to anything on the network. 2. try getting rid of the internal hyperlinks and see if that solves the problem Charles ______________________ Decision Models FastExcel 2.3 now available Name Manager 4.0 now available www.DecisionModels.com "Steve T" wrote in message ... Thanks for the reply Charles. The only hyperlinks within the spreadsheet are internal links (links to other worksheets within the same file). There are no DDE links, OLE links or any other data access links. There is a considerable amount of VBA, all of which I have written myself. None of which I would expect to be utilising the network. Is there something I need to look for here or that you may have had in mind? Thanks. Steve "Charles Williams" wrote: Does the spreadsheet contain any Hyperlinks, DDE links, OLE links or any other kind of link? Is there any VBA used? Charles ______________________ Decision Models FastExcel 2.3 now available Name Manager 4.0 now available www.DecisionModels.com "Steve Telford" wrote in message ... Hi everyone, I've got a bit of a strange one here, I'm still investigating but thought I might post in case anyone has any ideas. We have a quite complex spreadsheet (Excel 2003) where the speed of calculations had started to become an issue. Upon investigation of the speed issues it became apparent that most of the time, when performing the calculation operaton (either automatically or by pressing F9) a network spike would show in the LAN section of the 'Networking' tab in Task Manager. This spike appears only when calculating and drops back down to 0% as soon as the calculation is complete. This spreadsheet is running completely locally (C drive). There are no links to spreadsheets anywhere on the network. We found that if you unplug the network cable, then the calculation speed is only a fraction of the time, and obviously there is no network activity showing in the task manager. To add further confusion to the problem, it does not appear to happen every time. There are times (so far they seem random, but I'm still looking for a pattern), where you open the spreadsheet and calculation is fast, and no network activity is present. Due to the fact that this activity perfectly coincides with the calculation, I don't believe this has anything to do with any software updates from other applications. Any help/ideas/advice would be welcomed. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation Speed | Excel Worksheet Functions | |||
calculation speed of Excel 2003 and Excel 2000 | Excel Discussion (Misc queries) | |||
Calculation speed issue | Excel Discussion (Misc queries) | |||
Calculation Speed | Excel Discussion (Misc queries) | |||
Maximum Calculation Speed | Excel Worksheet Functions |