Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel fails to save properly
I have a daily exercise in which I copy a web-based datagrid and paste it
into an Excel workbook. It's typically up to 6,000 rows +/- and 15 columns wide. It takes a while to paste. After that I block format remove text-wrap and adjust row height and column widths to fit, change the worksheet tab to a description name, then attempt to SAVE AS "XXXX_YYYY-MM-DD.XLS". At this point the worksheet usually becomes unresponsive but not always. If I close Excel and then reopen it, the recovered file can eventually be repaired and saved. Is this a known problem? I suspect that it may have something to do with non-visible html. Are there any techniques to do this process faster and reliably? George - Houston |
#2
|
|||
|
|||
George,
I would use the Clean function and Trim functions on the data. Remove all formatting, including any merged cells. Save the file. Then do your thing. Jim Cone San Francisco, USA "Rolls" wrote in message ... I have a daily exercise in which I copy a web-based datagrid and paste it into an Excel workbook. It's typically up to 6,000 rows +/- and 15 columns wide. It takes a while to paste. After that I block format remove text-wrap and adjust row height and column widths to fit, change the worksheet tab to a description name, then attempt to SAVE AS "XXXX_YYYY-MM-DD.XLS". At this point the worksheet usually becomes unresponsive but not always. If I close Excel and then reopen it, the recovered file can eventually be repaired and saved. Is this a known problem? I suspect that it may have something to do with non-visible html. Are there any techniques to do this process faster and reliably? George - Houston |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel not recognizing Dates properly. | Excel Discussion (Misc queries) | |||
Excel 2003 does not prompt to save changes when closing? | Excel Discussion (Misc queries) | |||
Save prompt for Excel 2003 | Setting up and Configuration of Excel | |||
I used Save instead of Save As in Excel. How can I get my origin. | Excel Discussion (Misc queries) | |||
How do I save a record from an excel template to a database in a . | Excel Discussion (Misc queries) |