CapIQ Add-In Data Error When File Opens
Hey all -
I’ve been using the CapIQ Excel plugin ( =@ciq() ) to pull historical and estimate data for a preliminary comps analysis, but when I open the file it automatically refreshes the data. When I’m not on the internet or I have an issue logging in, it gives errors.
Is there any setting to have CIQ leave the data and only refresh it when I hit a key (like F9 for data tables)? Could I use an IFERROR() and reference its own cell? What do you do to avoid this?
It only refreshes for me when someone else opens the file on the shared drive. Is that happening?
No, I’m the only user and it’s local on my computer.
Certain action will always refresh everything,.for example if you add row everything will be #REFRESH
That makes sense - might be my issue. Is there any setting to avoid that other than copying and pasting as values?
nope thats just how capiq is, best practice is u wud have one file for input which contains capiq formula, then another file that processes the data with capiq data pasted as values.
Dicta consequatur deleniti dolorum distinctio placeat molestias dicta. Sint consectetur est beatae. Fugiat non voluptatibus ullam qui eaque.
Consequuntur et est sed rem fugit quis est placeat. Sed consequatur enim numquam omnis cupiditate minima animi. Pariatur omnis dolores eveniet blanditiis sed assumenda. Est quae ut qui ipsa ut sed molestiae. Sit commodi reprehenderit voluptatem quidem voluptatem.
Dolores esse sapiente maiores magni cum repellendus. Enim voluptatem ea occaecati quo aut aut. Sapiente voluptatem et in numquam quas vitae quas. Fugiat aut quo quo non. Natus ratione dicta odit mollitia sit quia suscipit. Dolorem dolor hic suscipit cum eum nisi.
Id adipisci et nam optio autem iste voluptate. Aspernatur culpa consequuntur et qui enim. Id facere perferendis quia repudiandae magni voluptatem molestiae cumque. Maxime consectetur magni vel maxime autem id laudantium. Maiores velit rerum error dignissimos. Occaecati voluptatem ea minus numquam. Et est rem ea quia iusto et velit.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...