Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Refreshing Workbook Connections with Access

In Excel, I have workbook connections set up to import data from Access
tables and queries. Whenever I 'refresh' those connections, I get an
(un-numbered) error message as follows: "This operation is not allowed. The
operation is attempting to shift cells in a table on your worksheet."

My understanding is that these connections should readily refresh. Right
now, each time I want to refresh the connections, I must recreate the
connections from scratch. Any ideas about how to resolve this issue?
Reply
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
Order of columns in Workbook Connections FullCity Consulting Inc. Excel Worksheet Functions 1 July 30th 08 01:52 PM
Refreshing a linked Access Database Rob Excel Discussion (Misc queries) 0 October 17th 07 12:40 AM
Refreshing Excel worksheet with data linked from Access mcphc Excel Discussion (Misc queries) 1 March 23rd 07 05:16 PM
Why are the cells of my workbook not refreshing? Kurt Paradise Excel Worksheet Functions 1 April 7th 05 03:09 PM
Refreshing Access data in Excel Jimmy G Excel Discussion (Misc queries) 0 December 21st 04 03:53 PM


All times are GMT +1. The time now is 04:06 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"