Excel challenge
Thread poster: Gillian Searl

Gillian Searl  Identity Verified
United Kingdom
Local time: 12:37
Member (2004)
German to English
Apr 24, 2008

Hi, my dad usually does my bookkeeping and invoicing and has disappeared off to China for a month leaving my sister with the dubious privilege. Dad uses a rather complicated method involving Excel and has left my sister with a problem:

The job involves invoicing using a set of 4 spreadsheets which use pivot tables (whatever they are). I have to refresh one of the files and when I do so I get an error message saying that it "Cannot open Pivot Table source file xxx". The xxx is the file path on my dad's computer to where the files are stored. I have tried to set up that path on my computer but I'm using Windows Vista and it won't let me create the folder Documents and Settings on the C drive. It looks to me like I need to work out how to tell the Refresh where to look on my computer for the files it needs for this pivot table.

Does anyone know how to do this in Excel 2007 and can tell me in simple terms?

Thanks for any assistance you can provide.
Gillian


 

Jan Sundström  Identity Verified
Sweden
Local time: 13:37
English to Swedish
+ ...
Vista challenge Apr 24, 2008

Gillian Searl wrote:

Hi, my dad usually does my bookkeeping and invoicing and has disappeared off to China for a month leaving my sister with the dubious privilege. Dad uses a rather complicated method involving Excel and has left my sister with a problem:

The job involves invoicing using a set of 4 spreadsheets which use pivot tables (whatever they are). I have to refresh one of the files and when I do so I get an error message saying that it "Cannot open Pivot Table source file xxx". The xxx is the file path on my dad's computer to where the files are stored. I have tried to set up that path on my computer but I'm using Windows Vista and it won't let me create the folder Documents and Settings on the C drive. It looks to me like I need to work out how to tell the Refresh where to look on my computer for the files it needs for this pivot table.

Does anyone know how to do this in Excel 2007 and can tell me in simple terms?

Thanks for any assistance you can provide.
Gillian


Hi Gillian,

This is more of a Vista challenge than an Excel challenge. All the security warnings and "can't do this" is such a nuisance...

My first suggestion would be: buy/borrow an old laptop from a friend, that runs a more reasonable Windows version. Move all the files, and do your work there instead!

Second suggestion: you can actually tweak Vista and create folders. What most people do is to abandon the native file browser, and install a trial of Total Commander or other alternative explorer. TC will ignore all stupid warnings and actually do what you tell the computer to do!icon_wink.gif

Good luck,

/J


 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Excel challenge

Advanced search






memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »
CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search