Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ODBC Overwrite existing cells
An option I'm used to has disappeared in Office 2007.
I use the query wizard to pull data from an access database to a excel template. The worksheet has formulas that run from k2 to q2500. (some of these cells are named also) In previous versions just prior to filling the sheet with the data I would click on properties and click on Overwrite existing cells. (without this option it inserts and that messes up my calculations) Now in 2007 I see that is only available under properties for Upon refresh. Any help would be greatly appreciated. Thanks in advance, Chuck Dobbs |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating only non-empty cells... | Excel Worksheet Functions | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Chg existing cells fr Proper to Upper w/o re-typing. | Excel Discussion (Misc queries) | |||
getting data from cells in wrksheet & importing in existing works | Excel Discussion (Misc queries) | |||
How to add another line in cells with existing text? | New Users to Excel |