Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleted columns reset their width to zero
In the course of routine spreadsheet maintenance I delete unused
columns and rows to reset the lower right corner of the spreadsheet, in an attempt to optimize use of spreadsheet resources and reduce file size. In one tab of a particular workbook, when I delete unused columns their column width resets to zero, hiding them. It only happens in that one tab: other tabs in the same workbook behave normally. Don't know if this is a relevant data point: I sent this file to Europe for use by colleagues there, and some formulas came back translated into another language (EDATE became EDATUM, for instance). Anyone seen this before? Thanks, Dave O Eschew obfuscation |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleted columns reset their width to zero
Any chance the last column (IV) has a zero width?
-- Jim "Dave O" wrote in message ... | In the course of routine spreadsheet maintenance I delete unused | columns and rows to reset the lower right corner of the spreadsheet, | in an attempt to optimize use of spreadsheet resources and reduce file | size. | | In one tab of a particular workbook, when I delete unused columns | their column width resets to zero, hiding them. It only happens in | that one tab: other tabs in the same workbook behave normally. | | Don't know if this is a relevant data point: I sent this file to | Europe for use by colleagues there, and some formulas came back | translated into another language (EDATE became EDATUM, for instance). | | Anyone seen this before? | | Thanks, | Dave O | Eschew obfuscation |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleted columns reset their width to zero
Are there hidden columns around the column being deleted? That is the only
reason I can think of. Also have you ever checked the change in file size after deleting few blank columns? "Dave O" wrote: In the course of routine spreadsheet maintenance I delete unused columns and rows to reset the lower right corner of the spreadsheet, in an attempt to optimize use of spreadsheet resources and reduce file size. In one tab of a particular workbook, when I delete unused columns their column width resets to zero, hiding them. It only happens in that one tab: other tabs in the same workbook behave normally. Don't know if this is a relevant data point: I sent this file to Europe for use by colleagues there, and some formulas came back translated into another language (EDATE became EDATUM, for instance). Anyone seen this before? Thanks, Dave O Eschew obfuscation |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleted columns reset their width to zero
No, no hidden columns at all. I also copied a column from a blank file
and pasted it into the tab to see if I could overwrite something, and checked for background VB code. This doesn't affect the spreadsheet at all (as far as I can tell); I don't like unexplained events in financial spreadsheets. Dave O Eschew obfuscation |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleted columns reset their width to zero
If it does not contain confidential information then can you mail it to me
to_sheeloo and append @hotmail.com "Dave O" wrote: No, no hidden columns at all. I also copied a column from a blank file and pasted it into the tab to see if I could overwrite something, and checked for background VB code. This doesn't affect the spreadsheet at all (as far as I can tell); I don't like unexplained events in financial spreadsheets. Dave O Eschew obfuscation |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tab key jumps several columns. How can I reset tab key to default | Excel Discussion (Misc queries) | |||
deleted columns and limited size of worksheet | Excel Worksheet Functions | |||
accidentally deleted two columns, can I recover them | Excel Discussion (Misc queries) | |||
Deleted Columns replaced with formatted columns | Excel Discussion (Misc queries) | |||
deleted 2 columns by mistake - what do I do | Excel Discussion (Misc queries) |