TechQA.

Question

Append new data to an External Data table in Excel

score 3286 · Answer 1 · 2011-02-21T17:05:47.070000

0

Answer

3286

Views

Append new data to an External Data table in Excel

3.2k views Asked by dotNetkow At 21 February 2011 at 17:05

score 83 · Answer 2 · 2023-11-08T12:18:01.350000

How to Determine if the Refresh of a Workbook Query has Failed

83 views Asked by Jazza At 08 November 2023 at 12:18

score 960 · Answer 3 · 2017-05-23T02:24:19.017000

Changing the Server in the Excel External data Connection

960 views Asked by Ramya At 23 May 2017 at 02:24

score 1610 · Answer 4 · 2013-07-24T16:45:35.437000

Listen to refresh events in excel

1.6k views Asked by Christoph At 24 July 2013 at 16:45

score 377 · Answer 5 · 2017-08-02T10:33:37.770000

Make Excel external references relative

377 views Asked by Luigi Russo At 02 August 2017 at 10:33

score 162 · Answer 6 · 2019-10-25T15:40:31.917000

How can I compare queried data with input data in excel, and then use that comparison in a conditional formatting rule?

162 views Asked by ColonelMustard At 25 October 2019 at 15:40

score 42 · Answer 7 · 2019-10-30T15:50:23.967000

Text to Column tool is interrupting my conditional formatting

42 views Asked by ColonelMustard At 30 October 2019 at 15:50

score 81 · Answer 8 · 2023-07-13T11:29:36.460000

Stop data connection file opening on refresh

81 views Asked by ajr45 At 13 July 2023 at 11:29

score 456 · Answer 9 · 2014-06-16T20:15:55.627000

Shape click opens external data tab

456 views Asked by user3746096 At 16 June 2014 at 20:15

score 1379 · Answer 10 · 2011-04-04T14:10:09.807000

Excel Web Query Does not refresh

1.3k views Asked by yuben At 04 April 2011 at 14:10

score 171 · Answer 11 · 2021-11-23T08:06:55.123000

VLOOKUP Excel returns #N/A for my boss, but not for me

171 views Asked by Cosmin Leonte At 23 November 2021 at 08:06

score 14844 · Answer 12 · 2016-08-25T06:49:02.763000

Error: "The query returned more data than will fit on a worksheet"

14.8k views Asked by Toli At 25 August 2016 at 06:49

score 1670 · Answer 13 · 2016-08-26T06:10:31.037000

How to avoid alert "You won't be able to undo the changes this action query is about to make to the data in a linked table or tables"

1.6k views Asked by Toli At 26 August 2016 at 06:10

score 1059 · Answer 14 · 2015-07-23T13:17:16.967000

Excel External Data Connection crashing on other users

1k views Asked by Adrian Chrostowski At 23 July 2015 at 13:17

score 2916 · Answer 15 · 2015-08-31T20:33:39.703000

Using Data from Web, how to login?

2.9k views Asked by BruceWayne At 31 August 2015 at 20:33

score 50971 · Answer 16 · 2010-04-25T11:51:35.960000

Excel macro to change external data query connections - e.g. point from one database to another

50.9k views Asked by Rory At 25 April 2010 at 11:51

score 903 · Answer 17 · 2010-04-25T11:57:43.497000

Excel macro to change location of .cub files used by pivot tables? (to allow .xls files that depend on .cub files to be moved)

903 views Asked by Rory At 25 April 2010 at 11:57

score 475 · Answer 18 · 2020-02-20T23:30:34.630000

Force Excel to keep sheet name when referencing external tables

475 views Asked by UEExcel At 20 February 2020 at 23:30

score 1579 · Answer 19 · 2013-04-15T11:50:02.383000

Edit External Data in Excel Table

1.5k views Asked by e-mre At 15 April 2013 at 11:50

score 160 · Answer 20 · 2019-11-19T10:21:44.557000

Use cell values from worksheet as part of SQL parameters

160 views Asked by Nelson Lau At 19 November 2019 at 10:21

TechQA.

List Question

Append new data to an External Data table in Excel

How to Determine if the Refresh of a Workbook Query has Failed

Changing the Server in the Excel External data Connection

Listen to refresh events in excel

Make Excel external references relative

How can I compare queried data with input data in excel, and then use that comparison in a conditional formatting rule?

Text to Column tool is interrupting my conditional formatting

Stop data connection file opening on refresh

Shape click opens external data tab

Excel Web Query Does not refresh

VLOOKUP Excel returns #N/A for my boss, but not for me

Error: "The query returned more data than will fit on a worksheet"

How to avoid alert "You won't be able to undo the changes this action query is about to make to the data in a linked table or tables"

Excel External Data Connection crashing on other users

Using Data from Web, how to login?

Excel macro to change external data query connections - e.g. point from one database to another

Excel macro to change location of .cub files used by pivot tables? (to allow .xls files that depend on .cub files to be moved)

Force Excel to keep sheet name when referencing external tables

Edit External Data in Excel Table

Use cell values from worksheet as part of SQL parameters

Popular Questions

Popular Tags

Trending Questions