| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Slow speed opening XLSM compared to XLS
I have a file about 3Mb in the "wonderful" Vs7 format. ie with the XLSM
extension. It takes about 1 minute to open up, and then is quite sluggish and prone to breakdown. I saved it as an XLS file, and remarkably, it saved it with a few Kbs less, but opens in less than 2 seconds! I thought the new version was supposed to make smaller files and work faster. I have a 2.66MHz Celron with 1Gb ram running on XP Pro. Rob |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Slow speed opening XLSM compared to XLS
Such is life in Office 2007? Almost everyone switching to it that has taken
the time to comment about it has the general impression that it's slower than previous versions (of Excel). And with that CPU/RAM setup, you don't even want to think about upgrading that machine to Vista. "RobN" wrote: I have a file about 3Mb in the "wonderful" Vs7 format. ie with the XLSM extension. It takes about 1 minute to open up, and then is quite sluggish and prone to breakdown. I saved it as an XLS file, and remarkably, it saved it with a few Kbs less, but opens in less than 2 seconds! I thought the new version was supposed to make smaller files and work faster. I have a 2.66MHz Celron with 1Gb ram running on XP Pro. Rob |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Slow speed opening XLSM compared to XLS
RobN,
Also, here are a couple of links to some recent discussions of speed issues and Office/Excel 2007 that may give you some ideas of other areas to look into, such as DDE settings and 3rd party, seemingly unrelated applications, and/or anti-virus tools being potential culprits in this situation: http://www.dslreports.com/forum/r205...-opening-files http://www.dslreports.com/forum/r204...-open-document Good advice in that forum: it's moderated by two MSFT MVPs and lots of sharp help at the site itself. "RobN" wrote: I have a file about 3Mb in the "wonderful" Vs7 format. ie with the XLSM extension. It takes about 1 minute to open up, and then is quite sluggish and prone to breakdown. I saved it as an XLS file, and remarkably, it saved it with a few Kbs less, but opens in less than 2 seconds! I thought the new version was supposed to make smaller files and work faster. I have a 2.66MHz Celron with 1Gb ram running on XP Pro. Rob |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Slow speed opening XLSM compared to XLS
Thanks for that. I'll certainly check those out!
Rob "JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ... RobN, Also, here are a couple of links to some recent discussions of speed issues and Office/Excel 2007 that may give you some ideas of other areas to look into, such as DDE settings and 3rd party, seemingly unrelated applications, and/or anti-virus tools being potential culprits in this situation: http://www.dslreports.com/forum/r205...-opening-files http://www.dslreports.com/forum/r204...-open-document Good advice in that forum: it's moderated by two MSFT MVPs and lots of sharp help at the site itself. "RobN" wrote: I have a file about 3Mb in the "wonderful" Vs7 format. ie with the XLSM extension. It takes about 1 minute to open up, and then is quite sluggish and prone to breakdown. I saved it as an XLS file, and remarkably, it saved it with a few Kbs less, but opens in less than 2 seconds! I thought the new version was supposed to make smaller files and work faster. I have a 2.66MHz Celron with 1Gb ram running on XP Pro. Rob |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Slow speed opening XLSM compared to XLS
"Upgrading to Vista". Isn't that an oxymoron?
Rob "JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ... Such is life in Office 2007? Almost everyone switching to it that has taken the time to comment about it has the general impression that it's slower than previous versions (of Excel). And with that CPU/RAM setup, you don't even want to think about upgrading that machine to Vista. "RobN" wrote: I have a file about 3Mb in the "wonderful" Vs7 format. ie with the XLSM extension. It takes about 1 minute to open up, and then is quite sluggish and prone to breakdown. I saved it as an XLS file, and remarkably, it saved it with a few Kbs less, but opens in less than 2 seconds! I thought the new version was supposed to make smaller files and work faster. I have a 2.66MHz Celron with 1Gb ram running on XP Pro. Rob |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Slow speed opening XLSM compared to XLS
Truly ROFLM*O!!!
"RobN" wrote: "Upgrading to Vista". Isn't that an oxymoron? Rob "JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ... Such is life in Office 2007? Almost everyone switching to it that has taken the time to comment about it has the general impression that it's slower than previous versions (of Excel). And with that CPU/RAM setup, you don't even want to think about upgrading that machine to Vista. "RobN" wrote: I have a file about 3Mb in the "wonderful" Vs7 format. ie with the XLSM extension. It takes about 1 minute to open up, and then is quite sluggish and prone to breakdown. I saved it as an XLS file, and remarkably, it saved it with a few Kbs less, but opens in less than 2 seconds! I thought the new version was supposed to make smaller files and work faster. I have a 2.66MHz Celron with 1Gb ram running on XP Pro. Rob |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Slow speed opening XLSM compared to XLS
Sorry....don't know that acronym.
Rob "JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ... Truly ROFLM*O!!! "RobN" wrote: "Upgrading to Vista". Isn't that an oxymoron? Rob "JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ... Such is life in Office 2007? Almost everyone switching to it that has taken the time to comment about it has the general impression that it's slower than previous versions (of Excel). And with that CPU/RAM setup, you don't even want to think about upgrading that machine to Vista. "RobN" wrote: I have a file about 3Mb in the "wonderful" Vs7 format. ie with the XLSM extension. It takes about 1 minute to open up, and then is quite sluggish and prone to breakdown. I saved it as an XLS file, and remarkably, it saved it with a few Kbs less, but opens in less than 2 seconds! I thought the new version was supposed to make smaller files and work faster. I have a 2.66MHz Celron with 1Gb ram running on XP Pro. Rob |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Slow speed opening XLSM compared to XLS
Old internet 'shorthand' (also used in phone text messaging) : Rolling On
[the] Floor, Laughing My *55 Off. This page lists it along with links to several others you may run into from time to time: http://www.urbandictionary.com/define.php?term=roflmao That is, very humorous statement (and probably true in your case). I've only got 1 of 4 machines running Vista, and it was one specifically built to be able to handle Vista Ultimate. Actually pretty stable system. Has Office 2007 on it also: Intel Core-Duo 6600 (2.4GHz) with 2GB RAM along with 4GB flash as "ReadyBoost" RAM. "RobN" wrote: Sorry....don't know that acronym. Rob "JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ... Truly ROFLM*O!!! "RobN" wrote: "Upgrading to Vista". Isn't that an oxymoron? Rob "JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ... Such is life in Office 2007? Almost everyone switching to it that has taken the time to comment about it has the general impression that it's slower than previous versions (of Excel). And with that CPU/RAM setup, you don't even want to think about upgrading that machine to Vista. "RobN" wrote: I have a file about 3Mb in the "wonderful" Vs7 format. ie with the XLSM extension. It takes about 1 minute to open up, and then is quite sluggish and prone to breakdown. I saved it as an XLS file, and remarkably, it saved it with a few Kbs less, but opens in less than 2 seconds! I thought the new version was supposed to make smaller files and work faster. I have a 2.66MHz Celron with 1Gb ram running on XP Pro. Rob |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Slow speed opening XLSM compared to XLS
Thanks....always learning.
PS I don't know what "flash as "ReadyBoost" RAM" is, but it sounds like it ups your RAM besides the MB ram. If so, must investigate! Rob "JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ... Old internet 'shorthand' (also used in phone text messaging) : Rolling On [the] Floor, Laughing My *55 Off. This page lists it along with links to several others you may run into from time to time: http://www.urbandictionary.com/define.php?term=roflmao That is, very humorous statement (and probably true in your case). I've only got 1 of 4 machines running Vista, and it was one specifically built to be able to handle Vista Ultimate. Actually pretty stable system. Has Office 2007 on it also: Intel Core-Duo 6600 (2.4GHz) with 2GB RAM along with 4GB flash as "ReadyBoost" RAM. "RobN" wrote: Sorry....don't know that acronym. Rob "JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ... Truly ROFLM*O!!! "RobN" wrote: "Upgrading to Vista". Isn't that an oxymoron? Rob "JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ... Such is life in Office 2007? Almost everyone switching to it that has taken the time to comment about it has the general impression that it's slower than previous versions (of Excel). And with that CPU/RAM setup, you don't even want to think about upgrading that machine to Vista. "RobN" wrote: I have a file about 3Mb in the "wonderful" Vs7 format. ie with the XLSM extension. It takes about 1 minute to open up, and then is quite sluggish and prone to breakdown. I saved it as an XLS file, and remarkably, it saved it with a few Kbs less, but opens in less than 2 seconds! I thought the new version was supposed to make smaller files and work faster. I have a 2.66MHz Celron with 1Gb ram running on XP Pro. Rob |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Slow speed opening XLSM compared to XLS
ReadyBoost is kind of a Vista thing. It allows you to attach a 'thumb drive'
type USB device to the system and Vista will use it for swap file and other temporary operations. Faster than going to the hard drive. Wikipedia has a good writeup about it: http://en.wikipedia.org/wiki/ReadyBoost If (when) you end up with a Vista system, look for USB devices marked as suitable to use for a ReadyBoost device. Be sure to read the section on "Performance" on the Wikipedia page. Yes, we all learn something almost every day around here. "RobN" wrote: Thanks....always learning. PS I don't know what "flash as "ReadyBoost" RAM" is, but it sounds like it ups your RAM besides the MB ram. If so, must investigate! Rob "JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ... Old internet 'shorthand' (also used in phone text messaging) : Rolling On [the] Floor, Laughing My *55 Off. This page lists it along with links to several others you may run into from time to time: http://www.urbandictionary.com/define.php?term=roflmao That is, very humorous statement (and probably true in your case). I've only got 1 of 4 machines running Vista, and it was one specifically built to be able to handle Vista Ultimate. Actually pretty stable system. Has Office 2007 on it also: Intel Core-Duo 6600 (2.4GHz) with 2GB RAM along with 4GB flash as "ReadyBoost" RAM. "RobN" wrote: Sorry....don't know that acronym. Rob "JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ... Truly ROFLM*O!!! "RobN" wrote: "Upgrading to Vista". Isn't that an oxymoron? Rob "JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ... Such is life in Office 2007? Almost everyone switching to it that has taken the time to comment about it has the general impression that it's slower than previous versions (of Excel). And with that CPU/RAM setup, you don't even want to think about upgrading that machine to Vista. "RobN" wrote: I have a file about 3Mb in the "wonderful" Vs7 format. ie with the XLSM extension. It takes about 1 minute to open up, and then is quite sluggish and prone to breakdown. I saved it as an XLS file, and remarkably, it saved it with a few Kbs less, but opens in less than 2 seconds! I thought the new version was supposed to make smaller files and work faster. I have a 2.66MHz Celron with 1Gb ram running on XP Pro. Rob |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Slow speed opening XLSM compared to XLS
Thanks for all your advice; will tuck it away for future reference.
Rob "JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ... ReadyBoost is kind of a Vista thing. It allows you to attach a 'thumb drive' type USB device to the system and Vista will use it for swap file and other temporary operations. Faster than going to the hard drive. Wikipedia has a good writeup about it: http://en.wikipedia.org/wiki/ReadyBoost If (when) you end up with a Vista system, look for USB devices marked as suitable to use for a ReadyBoost device. Be sure to read the section on "Performance" on the Wikipedia page. Yes, we all learn something almost every day around here. "RobN" wrote: Thanks....always learning. PS I don't know what "flash as "ReadyBoost" RAM" is, but it sounds like it ups your RAM besides the MB ram. If so, must investigate! Rob "JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ... Old internet 'shorthand' (also used in phone text messaging) : Rolling On [the] Floor, Laughing My *55 Off. This page lists it along with links to several others you may run into from time to time: http://www.urbandictionary.com/define.php?term=roflmao That is, very humorous statement (and probably true in your case). I've only got 1 of 4 machines running Vista, and it was one specifically built to be able to handle Vista Ultimate. Actually pretty stable system. Has Office 2007 on it also: Intel Core-Duo 6600 (2.4GHz) with 2GB RAM along with 4GB flash as "ReadyBoost" RAM. "RobN" wrote: Sorry....don't know that acronym. Rob "JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ... Truly ROFLM*O!!! "RobN" wrote: "Upgrading to Vista". Isn't that an oxymoron? Rob "JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message ... Such is life in Office 2007? Almost everyone switching to it that has taken the time to comment about it has the general impression that it's slower than previous versions (of Excel). And with that CPU/RAM setup, you don't even want to think about upgrading that machine to Vista. "RobN" wrote: I have a file about 3Mb in the "wonderful" Vs7 format. ie with the XLSM extension. It takes about 1 minute to open up, and then is quite sluggish and prone to breakdown. I saved it as an XLS file, and remarkably, it saved it with a few Kbs less, but opens in less than 2 seconds! I thought the new version was supposed to make smaller files and work faster. I have a 2.66MHz Celron with 1Gb ram running on XP Pro. Rob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening .xlsm workbooks in older versions of excel | Excel Discussion (Misc queries) | |||
| Excel 2007 VBA-XLL macro speed slow | Excel Discussion (Misc queries) | |||
| Slow speed Excel with Centrino duo | Excel Discussion (Misc queries) | |||
| Speed up and slow down, the auto-scroll. | Excel Discussion (Misc queries) | |||
| Why is the subtotal function in excel 2003 very slow compared to . | Excel Worksheet Functions | |||
![RobN[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
