(952) 890-7770
Zkarlo.com provides discount and used laptop parts...
Answer
need a product key for my compaq laptop the one given isn't working please help
Problem for Microsoft Office Professional 2007 Full Version for PC
Excel locks file when using data connection to other sheet.
Is there a command / macro that can be run to unlink a file after it has been "refreshed" from excel
Clarification Request
Posted by jljonesiii on Oct 15, 2008
There is a addin called "dellink.xla" that you can use to delete the link
(see http://support.microsoft.com/?id=188449), but if you need to keep the
results from the link, then you have to manually copy the cells, and paste
it as values, or use Excel 2002 or 2003 to remove the link.
Same Problem
Apr 28, 2009
- I'm using Excel 2007 Data Connections as a source for data to use in a Pivot Table. The source data is another Excel file with multiple sheets. The source data is located on one of the sheets in the Excel source file that has a named range to identify the data source location on the source sheet.I setup a data connection by pointing to the source file location and named range setup in the source file. The source file is open. I select the Data Connection as the data source for the pivot table. The data is imported successfully and the refresh function is working.
I then close the source file and the pivot table will no longer refresh. The pivot table can't find the data. The only thing that changed was to close the source file. I'm not understanding how the data connections work. Then I open the source file and the pivot table still won't refresh and has the same problem. - PalmsWest
Popular Solutions for Microsoft Office Professional
Questions and Unsolved Problems for Microsoft Office Professional
Do you recommend Microsoft Office Professional 2007 Full Version for PC?
Answer
Answer
Hard drive crashed and replaced by HP. MS Home/Student software was not reloaded by store, can't...
(More)
Answer
need the key for the microsoft 2007
Answer
i get accsess error register key accsess error when itry to load 2007 office
Answer
after set my window vista there is only 25 times uses limt of microsoft office. and every time that...
(More)
Sponsored Links
Ask our Experts
Browse popular Problems
More Common Problems
Most Common Problems for:
For Microsoft Office Professional...:
Top Business and Pro... Experts
Experience:
Experienced a lot in computer troubleshooting.
Knowledgeable about cellular phones.
Ask Me
Top Computer & Laptop Repair
Best Business and Productivity
Recommended by Owners
Recommended by Owners
