Hello, I've been using data source tied to excel pivot table for years. The command text has always had parameter(s) set up as ?
Such as: CALL SPNAME(?,?,?), the parameters are mapped to cell locations. With XLSX and Office 365 work sheets, the cell locations 'disappear' when the spreadsheet is opened; and the spreadsheet blows up if the pivot table is refreshed. Please see attached document and example spreadsheets.
Requesting a way to 'keep' cell locations mapped to parameters. Please see document for full details on request.
31 freelancers are bidding on average $395 for this job
Excel expert!! I can quickly and accurately identify and fix the problem. ZERO ERROR GUARANTEED!! Please read my 400+ reviews; I am here to impress you with my work.
Hello Sir Im excel VBA macro and formula Expert :) i can help you to fix your excel please ping me now and im able to discuss more right now Thank you Galih
Hello, I am actually using 365 too, and I would love to help you fix your file. Please send me a message so that we can discuss in details your requirements. Looking forward to hearing from you, BR, Razvan