Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data connection and formatting problem
Hello,
I keep a log in Excel that's connected to some data that's stored elsewhere. I've shaded some of the cells in the log to indicate to myself that they're going to remain blank (as opposed to cells that are blank because I need to enter the data that belongs in them). However, if I re-sort the list, or if I refresh the data and a row is added that goes above any of the other ones, the data moves up or down a row, but the formatting stays in the same cells. Is there any way to link the formatting to the data in my log? Thanks, Kathleen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Connection | Excel Discussion (Misc queries) | |||
Importing:Data Connection Wizard Doesn't see Source Data - No Impo | Excel Discussion (Misc queries) | |||
Problem getting external data using an existing connection | Excel Discussion (Misc queries) | |||
always recheck data connection library for latest connection strin | Excel Discussion (Misc queries) | |||
always recheck data connection library in MOSS for latest data sou | Excel Discussion (Misc queries) |