Description:
Microsoft Office Excel newsgroup.
|
|
|
Shared Files - blown out margins
|
| |
We have an Excel workbook with about 50 worksheet tabs that is currently over 5MB. About 2-4 of us are in it making updates at any one time. We save a new version of the file daily. The problem is two-fold: 1) in two days time, the file size grew from 3.9MB to 5.2MB, when there weren't that many... more »
|
|
|
Date Picker
|
| |
Excel 2007 When I installed Office 2007 on my new computer, a file with a Date Picker will not work properly. I can install a new date picker and it will work until I shut down the file and re-open it, then it stops working, (just get the red x).
|
|
|
saving to xls in excel 2007
|
| |
having an issues. have workbook "wb1" with worksheet "ws1" as an .xls file i open wb1, create a new worksheet "ws2". input simle data in ws2. i save wb1, still .xls. ws2 data replaces ws1 data, ws2 disappears. if i open wb1, save as xlsx and do the same, there is no issues. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the... more »
|
|
|
VB bug
|
| |
This macro worked until now. Now the following code is skipped.(ActiveCell.Offset(1, 0).Select) 'endzone address = $E$100 'activecell.address = $E$10 'activecell.value = "" (empty) activecell.offset (2,0).select Do Until ActiveCell.Value <> "" Or ActiveCell.Address >= Range(EndZone).Address ActiveCell.Offset(1, 0).Select... more »
|
|
|
in xl..how to delete data and leave formulas
|
| |
hi select the sheet you want to delete data. press the F5 key to bring up the goto dialog. click the special button. form the list select constrants. ok all data that is not a formula should be high lighted. press the delete key. data gone, formulas still there. Regards FSt1
|
|
|
Excel 2007 and the Win 7 user interface
|
| |
The Win 7 user interface calls for windows that are dragged to the upper edge of the display to be expanded to fill the display. To minimise the application you then just pull the window away from the edge of the screen again. However, Excel 2007 only appears to implement the expansion of its window.... more »
|
|
|
Copying an Array formula
|
| |
I have multiple array lookups in one tab that refer to multiple tabs within the workbook. All of the formulas have copied just fine except the last one. It will only copy half way down the spreadsheet. When I try and copy it dow or input another formula, the cell just stays blank. Has anyone seen this... more »
|
|
|
Excel data import of tab-delimited text sees capital 'F' as delimi
|
| |
Has anyone come across a situation where, when importing a tab-delimited text file as data, text strings containing a capital 'F' get broken into seperate fields at the 'F'? If I enclose the text strings containing the 'F' with double-quotes they are accepted as is. If I change the capital 'F' to a lower-case 'f' there is no... more »
|
|
|
Problem printing landscape format in excel
|
| |
I have an HP C4640 and when I print-preview an excel sheet on landscape format I see the whole page, but it does not print the whole page. It switches back to protrait format and only prints the first 3 - 4 columns. I have updated printer drivers and re-installed printer. Can anyone advice?
|
|
|
|
