LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Multiple paste not allowed

I use a custom function for an SAP application that pushes data to a database:
=PutCtData("PKAMOUNT","AMOUNT",A1:A5,)

As soon as this function is included in a spreadsheet, regardless of whether
I am connected to the database or not, I can only paste once after copying
(vs. typically being able to paste as many times as I want to before the
clipboard is cleared). It's as if the 'calculate' F9 function is being run
after each paste.

Another similar formula to pull from the database does not cause this problem
=GetCtData("PKAMOUNT","AMOUNT",A1:A5,)

Any suggestions on how to deactivate this, or why it would arise?
 
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
allowed/taken Martha Excel Worksheet Functions 1 July 12th 07 04:07 PM
allowed / taken Martha Excel Worksheet Functions 3 July 11th 07 07:56 PM
macro copy/paste data from multiple cells to multiple cells Diana Excel Discussion (Misc queries) 0 July 10th 06 09:24 PM
MODIFICATION IS NOT ALLOWED lisasbulldogs Excel Worksheet Functions 1 May 31st 06 06:27 PM
parameters not allowed begrry Excel Discussion (Misc queries) 0 May 3rd 05 03:56 PM


All times are GMT +1. The time now is 01:59 AM.

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"