LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 25th 05, 02:10 PM
Posts: n/a

I have a problem with functions for a worksheet that imports SQL data thru a
query. (this may be a familure question from the 23rd of May, aprt of it was
answered). When it updates, it deletes some lines that have 'cleared' and
adds new lines. There are functions that add info that do some math. As these
rows get added and deleted, it seams to be eating up the pasted functions.
That is, when you paste functions for a thousand rows, you may delete 50 rows
a day and add 50 rows. soon the 50 new rows a day leave 950 pasted, the next
day 900 rows, etc. How can I enforce those 1000 rows' functions form getting
'eaten' by this effect. I'm not sure which setting controls this. thanks
ahead of time


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
Paste Functions and Update info jackle Excel Worksheet Functions 2 May 24th 05 06:55 PM
Can't Copy and Paste or Paste Special between Excel Workbooks wllee Excel Discussion (Misc queries) 4 April 5th 05 07:51 PM
Can't Copy and Paste between Excel 2003 Workbooks wllee Excel Discussion (Misc queries) 6 March 30th 05 02:59 PM
3 questions about automated c++ com add-in worksheet functions gert Excel Worksheet Functions 0 March 10th 05 09:57 AM
Paste functions into a new XLS Rush Excel Worksheet Functions 1 January 11th 05 09:37 PM

All times are GMT +1. The time now is 10:19 AM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017