| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula wont do its job on External Data Query
Hi everyone, I have an External Data Query set up (data that I take from an
Access database with this query to excel). The query seams to work great but when I insert a formula, they simply do not work. i.e: I have data (numbers) in A2, A3, A4 and want to SUM them, formula is accepted but will not sum them until I delete the data then type them up manually. It seams as this query is either formatting cells on an unknowns format (which shows no problem when I right-click it and see for formatting) or its just not possible to use formulas on data that come from an External Data Query set up. Any help is greatly appreciated! Thank you, Adnan Computer Student Student, Kosovo -- Please post all your inquiries on this community so we can all benefit - Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to do Edit Query from Import External Data. | Excel Discussion (Misc queries) | |||
| Get External Data - not editable using Query Wizard | Excel Discussion (Misc queries) | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Getting External Data with Saved Query | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
