We konden deze vermelding niet vinden. Er worden benaderende resultaten weergegeven. Controleer je spelling of stel voor deze term aan het woordenboek toe te voegen.
外部データ範囲
Excel puts the external data range in the location that you specify.
指定した場所に外部データ範囲が配置されます。
If your data source requires a password to connect to it, you can require that the password is entered before the external data range can be refreshed.
Click the worksheet that contains the external data range from which you want to remove the data connection.
データ接続を削除する外部データ範囲が含まれているワークシートをクリックします。
Remove data from the external data range before saving the workbook
ブックを保存する前に外部データ範囲からデータを削除する
If you continue the refresh, hyperlinks in the external data range will no longer work. Do you want to continue?
更新を続けると、データ範囲にあるハイパーリンクは無効になります。続けますか?
On the formula bar, click the arrow next to the Name box, and then click the name of the external data range from which you want to remove the data connection.
Remove data from the external data range before saving the workbook Select this check box if you want to save the workbook with the query definition but without the external data.
No data is currently displayed in this external data range. As a result, you can't hide the row numbers. Either refresh the external data range or change the query so that it returns data, then try the operation again.
Stored passwords are not encrypted and not recommended. If your data source requires a password to connect to it, you can require that the password is entered before the external data range can be refreshed. This procedure does not apply to data retrieved from a text file ( .txt) or a Web query ( .iqy).
Remove data from the external data range before saving the workbook Select this check box if you want to save the workbook with the query definition but without the external data. Clear this check box to save the query definition and data with the workbook. This check box becomes available only after you select the Refresh data when opening the file check box.
Cannot refresh a PivotTable report until the refresh operation for the external data range on which the report is based is complete. Wait until the spinning world icon no longer appears in the status bar, click a cell in the report, and then, with the PivotTable report selected, on the Options tab, in the Data group, click Refresh.
This Web query returned no change the query, click OK, click the arrow on the name box in the formula bar, click the name of the external data range for the Web query, right-click the selection, and then click Edit Query.
この Web クエリによって返されるデータがありません。クエリを変更するには、[OK] をクリックし、数式バーの名前ボックスの矢印をクリックします。次に Web クエリに使用する外部データ範囲の名前をクリックし、選択範囲を右クリックして、[クエリの編集] をクリックします。
Microsoft Office Excel cannot refresh a PivotTable report until refresh of the external data range on which the report is based is complete. When refresh is finished (the spinning world icon no longer appears in the status bar), click a cell in the report, and then click Refresh Data on the PivotTable toolbar.
Er worden alleen voorbeelden gegeven om u te helpen het woord of de woordcombinatie waarop u hebt gezocht, te vertalen. Deze worden niet door ons geselecteerd of gevalideerd en kunnen ongepaste taal bevatten. Wij vragen u melding te maken van voorbeelden die dienen te worden aangepast of verwijderd. Vertalingen met grof of informeel taalgebruik worden meestal rood of oranje gemarkeerd.