Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Excel2003 ... File size 140mg ... approx 80 WorkSheets ... each 100 Cols by
120 Rows ... each with 20+ Macro Buttons ... which I assume to be responsible for majority of File Size??? Above said ... I SAVED File to a USB Flash Drive in order to work from home .... (note: Inspite of File size ... File working Fine before saving to USB) Issue ... When attempting to open File (at home) ... My Excel Returns: 1: Excel can not perform this function with available resources ... Close other Apps ... OK Button ... (thing is, I have no other Apps running) 2: Once you click OK ... Excel attempts to "Repair" File ... then returns same warning message (Excel can not perform this function with available resources) ... Again an OK Button 3: Once you click OK ... Excel attempts to "Extract" File ... then returns same warning message (Excel can not perform this function with available resources) ... & of course the OK button. I copied file from Jump Drive to Hard Drive & then tried opening again, but got same error messages (only I got them faster) Above said ... I am stuck ... I thought I was going to have this done by Mon. So ... do any of you that are intimate with Excel know what is happening here? Thanks ... Kha |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Could the file on the jump drive be corrupt? Have you tried putting the file
on another jump drive. Use the Safely Remove tool before pulling drive from USB socket best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Ken" wrote in message ... Excel2003 ... File size 140mg ... approx 80 WorkSheets ... each 100 Cols by 120 Rows ... each with 20+ Macro Buttons ... which I assume to be responsible for majority of File Size??? Above said ... I SAVED File to a USB Flash Drive in order to work from home ... (note: Inspite of File size ... File working Fine before saving to USB) Issue ... When attempting to open File (at home) ... My Excel Returns: 1: Excel can not perform this function with available resources ... Close other Apps ... OK Button ... (thing is, I have no other Apps running) 2: Once you click OK ... Excel attempts to "Repair" File ... then returns same warning message (Excel can not perform this function with available resources) ... Again an OK Button 3: Once you click OK ... Excel attempts to "Extract" File ... then returns same warning message (Excel can not perform this function with available resources) ... & of course the OK button. I copied file from Jump Drive to Hard Drive & then tried opening again, but got same error messages (only I got them faster) Above said ... I am stuck ... I thought I was going to have this done by Mon. So ... do any of you that are intimate with Excel know what is happening here? Thanks ... Kha |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Dear Ken
Few thoughts.. 1. It is always better to copy that to the HDD and open. Just right click the file in explorer and check whether the file is read-only. Then close all programs running in your machine and attempt to open the file 2. Do you have any events triggered during workbook open. If so set the Tools|Macro|Security to high and try to open the workbook OR hold down the Shift key while opening the workbook to stop executing those. 3. Still you are having problems; try to open the same in another machine (if available) with more memory If this post helps click Yes --------------- Jacob Skaria "Ken" wrote: Excel2003 ... File size 140mg ... approx 80 WorkSheets ... each 100 Cols by 120 Rows ... each with 20+ Macro Buttons ... which I assume to be responsible for majority of File Size??? Above said ... I SAVED File to a USB Flash Drive in order to work from home ... (note: Inspite of File size ... File working Fine before saving to USB) Issue ... When attempting to open File (at home) ... My Excel Returns: 1: Excel can not perform this function with available resources ... Close other Apps ... OK Button ... (thing is, I have no other Apps running) 2: Once you click OK ... Excel attempts to "Repair" File ... then returns same warning message (Excel can not perform this function with available resources) ... Again an OK Button 3: Once you click OK ... Excel attempts to "Extract" File ... then returns same warning message (Excel can not perform this function with available resources) ... & of course the OK button. I copied file from Jump Drive to Hard Drive & then tried opening again, but got same error messages (only I got them faster) Above said ... I am stuck ... I thought I was going to have this done by Mon. So ... do any of you that are intimate with Excel know what is happening here? Thanks ... Kha |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Excel Discussion (Misc queries) | |||
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Setting up and Configuration of Excel | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
file open via IE hyperlink causes already open files to shrink and tile | Setting up and Configuration of Excel |