Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
automatically refresh excel data on
Name: stevedodkins Date: February 2, 2006 at 08:31:15 Pacific OS: XP Pro CPU/Ram: 1.5ghz
Comment:
Is it possible to open excel from a command line and to refresh the data as it does it?
Name: Jennifer SUMN Date: February 2, 2006 at 14:36:38 Pacific
Reply:
Of course it's possible to open Excel via a command line. As for refresh the data, you need to be much more specific. What type of data? Are the cells/sheets/workbook linked to others? Are you running any Macros when you open the workbook?
Soylent Green is PEOPLE!!!
0
Response Number 2
Name: stevedodkins Date: February 4, 2006 at 11:23:13 Pacific
Reply:
Hi, the spreadsheet gets it data via an odbc connection into an erp system, the file a customer file gets updated with new customers and when the spreadsheet is opened the users refresh the data but i would like the spreadsheet to do it automatically as it opens.
Regards
Steev
0
Response Number 3
Name: Jennifer SUMN Date: February 6, 2006 at 07:26:37 Pacific
Reply:
You could create an autoexec macro that contains only the F9 function, which calculates the data.
Soylent Green is PEOPLE!!!
0
Response Number 4
Name: stevedodkins Date: February 6, 2006 at 08:23:40 Pacific
Reply:
Its always best to keep it simple, many thanks - Recorded a macro called it Auto_Open and thats it.
Summary: Situation #2: I am working with a database where i am linking data from one sheet to sum in a cell on another sheet, and then from the cell to link to another sheet in a workbook. Why arent the totals...
Summary: When automatic refresh is used, is this a quick one-time (per session) action, or is the connection to the data source constant? I want to run an export from my school database (blackbaud) and save th...
Summary: Is it possible to recover data that has been erased on a excel 2000 spread sheet? Please note that this is not a file recovery issue as the file hasn't actually been deleted. What happened was a use...
0 
