Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Some formulas don't track copies, pastes, fill right, fill down
I have a problem with the new Excel TR2. I have an extensive file that I
update frequently. Some of the formulas in the cells are quite complex. When I want to do some new stuff, I usually select a column of cells and the next column to the right, and then hit ctrl-r to copy right. In the past with Office 2007, this has worked just as I expected; i.e. formulas in the cell are automatcially incremented in the news column. E.g., if one cell has the formulat "=G1" and I copy right, the new cell one row of has "=H1". Now it Excel doesn't do make the change from G column to H column in the new cell that I ctrl-r on (cut and paste also don't work). Althought it's more weird than than. Currenlty I have about 50 rows. If I select the last cell in row 1 and the next empty cell to the right, and then hit crtl-r, in my current case the old row has "data!GM1" and the new cell does update to "data!GN1." But IF I drag and select all 50 rows in the last column and the next empty column and ctrl-r, this new cell has "data!GM1," as does the rest of the rows. How do I fix this? Is this a bug or a setting? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Some formulas don't track copies, pastes, fill right, fill down
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Some formulas don't track copies, pastes, fill right, fill dow
Uh, Paul, Duh. I think this is a beta forum (linked to at least from the
Office Beta website). My post was not only to give MS some feedback about a potential problem, but also to help find a work around (or setting) if one existed. Okay, so with that aside, here is a work around and something for the MS gurus to look at. Seems that the problem is associated with conditional formatting. When I "clear rules from selected cells" before crtl-r or copy or anything else. Then do the ctrl-r, copy, etc., the cells update correctly into the new cells. Then I can go back to the previous cells that still contain the conditional formatting, and paste special, formats, and I'm back to where I wanted to be in the first place. A few extra steps here for now, but hopefully this is something MS can find and fix. MS folks, email me if you want and I can send the spreadsheet to you to look at. "paul" wrote: dont forget excel 2007 is still a beta! -- paul remove nospam for email addy! <snip "whiten" wrote: How do I fix this? Is this a bug or a setting? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel won't fill formulas | Excel Worksheet Functions | |||
Fill formulas down in macro | Excel Discussion (Misc queries) | |||
How do I auto fill formulas | Excel Worksheet Functions | |||
fill formulas and values | Excel Discussion (Misc queries) | |||
How do I fill down formulas so they iterate in intervals other th. | Excel Worksheet Functions |