(513) 874-3306
We fix and repair laptop motherboard no video, no...
Answer
my selection is blocked, i cant type any documents
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
wo ich den ursprünglichenn produktkey bekomme von mi
Answer
when I try to use mail merge in 2007, and complete the merge, it only pulls in the first three and...
(More)
Answer
Setup unable to find en-us/publr.cab file..................
Answer
i lost my manual for setting up zoom 2.0 webcam ( micro innovations ) model ic465c-f
Ask our Experts
Browse popular Problems
More Common Problems
Most Common Problems for:
For Microsoft Office Professional...:
Top Business and Pro... Experts
Experience:
I have owned a computer networking sales and service company.
Ask Me
Top Computer & Laptop Repair
Best Business and Productivity
Recommended by Owners
Recommended by Owners
