Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot tables
Resolved · Medium Priority · Version 2003
Candice has attended:
Excel Advanced course
when creating pivot tables can you use data from external program-not included in Microsoft, but running of an SQL Server?
Hi Candice
How are you doing, sorry not got back to you earlier
now it is very possible to get data from other programs that are not MS Office as long as the file type being used is a data file type when you save the you want to get externally as a data file from the save as type drop down list at the time you save
Hope this helps, feel free to reply for more calification
If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn
|
Excel tip:Convert Text into NumberSome times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions |
We'll call during UK business hours
Server loaded in 0.07 secs.