| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Format import from Database
Using v.2003. Everytime I "!Refresh Data" in a pivot table report, some
columns loose their format. I have to manually format these cells by selecting every cell and "PASTE SPECIAL,MULTIPLY by 1". Is there a better way? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Format import from Database
Put your cursor somewhere inside the Data Range.
Select... DataImport Export DataData Range Properties... In the 'Data Formatting & Layout' area, make sure that the 'Preserve Cell Formatting' check box is checked. -- HTH, Gary Brown If this post was helpful to you, please select ''YES'' at the bottom of the post. "SpaceCoorDinator" wrote: Using v.2003. Everytime I "!Refresh Data" in a pivot table report, some columns loose their format. I have to manually format these cells by selecting every cell and "PASTE SPECIAL,MULTIPLY by 1". Is there a better way? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell format with Data Import (date appearing as text) | Excel Discussion (Misc queries) | |||
| Using Excel for MySQL database import | Excel Discussion (Misc queries) | |||
| OT? Microsoft Works Database Import? | Excel Worksheet Functions | |||
| import paradox database into excel | Excel Discussion (Misc queries) | |||
| Import from Database using field from excel. | Excel Discussion (Misc queries) | |||
Linear Mode
