LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Retaining additional row info on refreshing data table

Hi,

I hope someone can help as I cannot find an answer anywhere.

Basically, I have setup a Microsoft SQL Query which I import into a
spreadsheet. I have added one or two extra columns manually so I can make
notes against each row of data.

However, when I refresh the data (which is done a lot as data is always
changing) it can mess up the adidtional columns i created manually and can
cause the notes I made to be positioned against a different row!

Does anyone know how I can refresh the data in a way it can keep the notes i
added manually for each row?

Any help will be much appreciated!!!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
refreshing data in a pivot table changes cell format pistolpete Excel Discussion (Misc queries) 1 July 27th 09 05:52 PM
Refreshing privot table data in 2007 smartgal Excel Discussion (Misc queries) 1 October 8th 08 06:50 PM
Pivot Table Refreshing of Data Paula Excel Discussion (Misc queries) 1 January 2nd 08 03:06 PM
Pivot Table does not remove old data when refreshing Rames Excel Discussion (Misc queries) 1 October 23rd 07 05:56 PM
Refreshing Data within a pivot table KeithB Excel Worksheet Functions 2 February 11th 06 11:20 AM


All times are GMT +1. The time now is 09:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"